Date from and to combo boxes on a form

  • Thread starter Thread starter Lindsey M
  • Start date Start date
L

Lindsey M

Hi everyone, hope you are well

Can anyone tell me the best way to put "Date From" and "Date To" combo boxes
on a form - I want it to be either a drop down box or calendar so the user
can just choose a date rather than typing it in.

I'm using Access 2000.

Any help would be greatly appreciated as I'm a tad stuck here! :o)

Cheers
Lindsey
 
Hi again

Ok, so what i've done is create a table (tblDays) with all the dates in up
to 2007.

I've created the two combo boxes, cboDateFrom and cboDateTo

I've got the DateFrom one working by using

SELECT [tblDays].[day_date] FROM tblDays WHERE [tblDays].[day_date]<date();

which shows only dates before today.

I now want the DateTo one to show all dates between the DateFrom value and
todays date but everything i try it just shows as blank.

Any ideas??

Thanks in advance
Lindsey
 
Back
Top