dh*****@daubert.com wrote in
news:11**********************@l41g2000cwc.googlegr oups.com:
I have a form that has two sub forms.
I would like to use the current value of one of the subform
fields as a search parameter in a query.
I tried pointing to the name of the form/field within the
query, but it didn't use the current field value as the search
criteria......I get the pop up Dialog that says "Enter
Parameter Value"......
I'm not sure what I'm doing wrong.
Any thoughts would be appreciated.
Doug
A control on a subform must be referred to via the main form's
name using the following hierchichical convention:
Forms!MainformName!SubformControlName.Form!subform fieldname.
Note that the SubformControlName may or not be the same as shown
in the forms panel of the database window. It must be the value
shown in the name property of the properties popup for the
subform as seen from the main form .
the same caveat applies to subformfieldname.
--
Bob Quintal
PA is y I've altered my email address.