Dropdown list from Recordset

[gblack]

I figure there's probably no way to do this, but I'll ask anyway...

As I am moving through my code, I'd like there to be a pop-up box which asks the user to choose from a list of dates. This list of dates only resides in a filtered recordset in the background.

Once the date is chosen, then my code continues onward...

I know I could make some sort of pop-up form, but I'd rather not have to go in a design all that just for a list of dates...

So, I guess I have two questions:

1) Is there such a thing as a dropdown list on a Input box?

and even if there isn't...

2) Is there a way I can bind the column in a recordset to a dropdown list?

Thanks,
Gary

 

[spikepl]

In Access there is no such thing as a drop down list. The name is combo box. This is important when looking for info in the documentation.

You could invent some user interface feature of your own: one could list the dates in an input box and select one there but this goes against all things access: stick to things familiar to users, do not invent new stuff. Talking about this and inventing takes longer than simply making a pop up form with a combobox or just combo box on your current form to select one of the dates, where the combo can be bound to the recordset of your choice at the time of your choice.

 

[jdraw]

By Dropdown, I think you mean Combobox.
And yes you can set the rowsource of the combo to a query (sql stmt) where you identify Dates.
see http://www.techonthenet.com/access/comboboxes/unique_values.php