criteria for a query

A

ANStech

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

Criteria in Querry to include All and Empty Field 9
query criteria 1
Adding data to MS Access from csv file 0
Word macro that can call cells out of Excel for a find and replace 0
Check Box query issue 3
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Running Report from Query using Open Form or Entering Criteria 1

Top