I am trying to create a form (in accrss 2003) where users can select information between 2 dates and then specify other criteria to narrow the search.
The form has 2 combo boxes with calendars that sets start and end dates and a command button runs a query refering to them as
Between [Forms]![Form1]![StartDate] And [Forms]![Form1]![EndDate]
This runs fine.
The other criteria are curently set by other combo boxes on the form. Since there are about 70 criteria, the combo box looks up values in a table. I want the query to looks up the value that is selected in the combo box. The combo box is unbound.
I have tried this: [Forms]![Form2]![Combo0] in the Criteria box but it gives no results.
Please help!
The form has 2 combo boxes with calendars that sets start and end dates and a command button runs a query refering to them as
Between [Forms]![Form1]![StartDate] And [Forms]![Form1]![EndDate]
This runs fine.
The other criteria are curently set by other combo boxes on the form. Since there are about 70 criteria, the combo box looks up values in a table. I want the query to looks up the value that is selected in the combo box. The combo box is unbound.
I have tried this: [Forms]![Form2]![Combo0] in the Criteria box but it gives no results.
Please help!
