+- 30 days in Drop Menu

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

Guest

I'm sure there is a way to fill a drop menu with the current day highlighted and then have the previous 10 days above it and the next 30 days below it. I just need someone to tell me how.

Anyone know how this would be done?
 
Ripper said:
I'm sure there is a way to fill a drop menu with the current day
highlighted and then have the previous 10 days above it and the next
30 days below it. I just need someone to tell me how.

Anyone know how this would be done?
Click to expand...

Something along the following lines should work:

You could have a table named, say, DayIncrements, with a single integer
field, DayIncrement, and store in that table records with values in that
field ranging -10 through 0 and back up to 30. Then you could base
your combo box on a rowsource query like this:

SELECT Date()+DayIncrement As SelectDate
FROM DayIncrements
ORDER By DayIncrement;

You'd set the combo box's Default Value to =Date().
 
Back
Top