Re: Select Dates

dmeiser wrote:
>I'm trying to fill a combo box with all dates from a specified date
>until now.
>
>Basically, what I want is something like "Select Date Where Date >=
>#8/1/2005#" but I don't want to use a table of dates as that would get
>ludicrously large and, I'm sure, wholly unnecessary. I'm just not sure
>how to do this.
>
>I would do it by just selecting the specific Date column from the
>tables, but that would require building very complex set of UNION
>queries and then adding a new month at the beginning of every month.
>Plus, not every day of the month appears in these columns.


There are three relevant ways to provide a set of data to a
combo box. One is the ValueList, which would be ludicrous
in this case. You've already said that you don't want to
use a table, so that's out. The third way is to use a call
back function as the RowSourceType.
See Help - RowSourceType - specific function code arguments
for all the details and an extensive example.

In AXP, you could also use a disconnected ADO recordset.
This would be sort of like using the call back function, but
probably easier to undestand I don't use ADO so I don't
any more about this approach.

--
Marsh
MVP [MS Access]
.