Using a combo box to filter dates in a query

LuigiCorleone

New member
Local time
Today, 22:52
Joined
May 14, 2002
Messages
7
Hi

I have a field in a query that must select all sale dates within a particular month. This month is passed from a combo box (cmbMonth) on a form (frmSalesByMonth).

I want to put the code on the criteria line.

I've got this far

Is Not Null And [Forms]![frmSalesByMonth]![cmbMonth]?????

Any help appreciated

Cheers

Luigi
 

Users who are viewing this thread

Back
Top Bottom