criteria for a query

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top