G Guest Oct 10, 2006 #1 How can I use a form with blank fields for a query? The user would enter one or more search values in the form.
How can I use a form with blank fields for a query? The user would enter one or more search values in the form.
D Douglas J. Steele Oct 10, 2006 #2 You put a reference to the control (Forms!NameOfForm!NameOfControl) as the criteria under the appropriate field in the query grid. Remember that to AND conditions together, you put them all on the same criteria row, to OR them together, you put them on separate rows.
You put a reference to the control (Forms!NameOfForm!NameOfControl) as the criteria under the appropriate field in the query grid. Remember that to AND conditions together, you put them all on the same criteria row, to OR them together, you put them on separate rows.
