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

  • Thread starter Thread starter ET
  • Start date Start date
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.
 
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?
 
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

Query Parameter using multiple options 0
Parameter Value error in a Subform 0
Use Parameter Form to export a query 3
how to pass a parameter to a query base of a query that is the base of a report 0
Parameter question for crosstab queries 1
Report Query Parameters 2
VBA query 4
Access Invalid bracketing of parameter name 1

Back
Top