Form criteria for a query

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hello
If i have a text box on a form to which a query gets its criteria from i.e.
[Forms]![myForm]![myControl]

how can i make it so that i can use john OR Bob OR etc to get the results
 
You cannot type multiple values into one text box, and use the text box in
the critiera of the query like that.

You could provide multiple text boxes, and set up the criteria as:
[Forms]![myForm]![myControl] OR [Forms]![myForm]![myOtherControl] OR ...
 
Back
Top