Using a form to enter query criteria..

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

Guest

I have designed a form which will select a staff member using a combo box and
have also added OK and Cancel buttons. I am trying to attach this form to a
query so that data will only be returned on the person selected using the
combo box.

I am looking for the statment that will need to be added to the relevant
field on the query if anyone can help me I would be very grateful. Thanks

Ian
 
Put something like the following in the criteria under the desired column...


=Forms![MySearchFormName]![MySearchFieldName]
 

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

Append Query Issue 0
Using a combo box as a criteria for a query 1
Default Query Criteria 1
Exclude items in a query 2
Search on entered or blank criteria 5
Multiple search Criteria 5
Using combo box(s) to create a query 1
Using Like in Criteria of a Query 1

Back
Top