query criteria

[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.

 

[SteveS]

2nd try - IE locked up - (again)...

When you get a dialog box asking for the parameter, it means that the query
couldn't find the control to get the value. It could be because the form is
not open or the form name and/or the control name is misspelled.

Note: it has to be the control name, not the control source (i.e. the
"Field" name in the table that the data comes from).

Steve