Dates in Combo Box

I

itsbarbara

I have a field with dates (past & future) and I want a combo box that will
show only the dates from the current date forward.
 
D

Devlin

In your cmb rowsource enter a SQL statement like so:

"SELECT DateField FROM TableName WHERE DateField >= Now() ORDER BY DateField
DESC"
 
I

itsbarbara

Perfect!! It worked. Thanks so much. Obviously I'm a newbie and so appreciate
your help!
 
V

Van T. Dinh

Beware that if you have today's value, it won't show up in your ComboBox.

From you description, you should use Date() rather than Now().
 
I

itsbarbara

Thank you Van...
I'm so glad that I found this discussion group. You all are great!!
 
Top