View Full Version : Using a combo box to filter dates in a query


LuigiCorleone
05-24-2002, 09:47 PM
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