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.

The form must be open when the query is run.
 
Back
Top