query parameter from open form field.....

[dhowell]

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

[shumaker]

I would be very interested in knowing this as well.

[Bob Quintal]

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.

[dhowell]

I have a subform that is in datasheet view.
The form has a variable # of rows based on the master form.

I want to be able to click on a value in one of the columns and open a
query that is based on that value.

I can use the "On dbl Click" event and use an Do.Cmd Openquery to open
the query......

How do I get it to use the particular cell value I clicked on as a
parameter?

Seems more dificult when the form is a "datasheet"...

How does Access identify the rows of a datasheet form, and how would
the "On dbl Click" event know what row you clicked on?????