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().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date format in a combo box 1
Help please: dates in combo box to bring up event or item 1
sum combo box based on other combo box 2
Filter tabular form by combo box 0
Combo box default value 3
Looking up 2 combo boxes and then calculate another field 1
Combo Box that fills Text Box in form 4
Using Combo Box selections to automatically populate fields 2

Back
Top