How use form for Query?

H

Harry Baya

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

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.
 
Top