Dates in Combo Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
In your cmb rowsource enter a SQL statement like so:

"SELECT DateField FROM TableName WHERE DateField >= Now() ORDER BY DateField
DESC"
 
Perfect!! It worked. Thanks so much. Obviously I'm a newbie and so appreciate
your help!
 
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().
 
Back
Top