How use form for Query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I use a form with blank fields for a query? The user would enter
one or more search values in the form.
 
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 must log in or register to reply here.

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

Copy record info into new form 0
Main Form and two Subforms 2
Using Between criteria to search query 1
OnClick on Combo Box opens a New Form 0
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Multiple query fields 1
Access Open Form with WhereCondition 6
Query by form issue 2

Back
Top