combo box - dates

  • Thread starter Thread starter Taher
  • Start date Start date
T

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.
 
If you've got a date, you can use the DateAdd function on it to adjust by
whatever factor you want.
 
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.
 
Back
Top