combo box - dates

[Taher]

Hi there

In my print screen of my database , i have user select the
date through a combo box. Now i want to program my combo
box in such a ways that if the user selects a date suppose
8/31/2004, then the combo box selects date 7/31/2004. In
other words i want to print reports of month prior to what
the user selects the date.

Taher Adenwala.

 

[Douglas J. Steele]

If you've got a date, you can use the DateAdd function on it to adjust by
whatever factor you want.

 

[Van T. Dinh]

Shouldn't you present the users with only end-of-month dates in the ComboBox
rather than letting the user selects any date.

You can use the Call-Back function to popupate the ComboBox with, says, the
dates of the last 12 completed months. Check Access Help on ComboBox.