Form criteria for a query

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
 
A

Allen Browne

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