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