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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Criteria from Form 3
Parameter Value error in a Subform 0
Access Dcount (multiple criteria) 3
Finding null 4
wildcard for date criteria to return all records 1
query not working 17
Search criteria for querys 3
form control 3

Back
Top