how do i use a form to provide parameters for a query?

E

ET

I'm trying to use a FORM (wth a Combo Box) to provide the parameters for a
Query. I tried using the MICROSOFT help but that didn't work.
 
B

BruceM

If the search form is named frmParam, and it has a text box named LastName,
set the criteria for the LastName field in the query to:
Forms!frmParam!LastName

The form needs to be opened before the query.

If you need further information, please provide greater detail. For
instance, what didn't work?
 

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

parameter query 1
Append Crosstab Query to Existing Table 0
Use Parameter Form to export a query 3
Too few parameters error with a IIF statement 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How do I clear a form? 0
Report Query Parameters 2
Cancelling out of parameter dialog box 0

Top