criteria for a query

G

Guest

I am trying to build a query. I want the criteria to be the value of a form
that I am working on. I tried [Forms]![frmMyForm]![MyFeild], but I keep
getting a dialog box asking for the parameter. When I type in the value, I
get the right result, but I don't want a dialog box, I just want Access to
find the value of the feild and use this for the criteria.
 
F

fredg

I am trying to build a query. I want the criteria to be the value of a form
that I am working on. I tried [Forms]![frmMyForm]![MyFeild], but I keep
getting a dialog box asking for the parameter. When I type in the value, I
get the right result, but I don't want a dialog box, I just want Access to
find the value of the feild and use this for the criteria.
Click to expand...

The form must be open when the query is run.
 

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 criteria 1
Parameter Value error in a Subform 0
Criteria in Querry to include All and Empty Field 9
Query Parameter using multiple options 0
Query not connecting 1
Combo box in Query criteria 6
Access Dcount (multiple criteria) 3
Parameter question for crosstab queries 1

Top