Subform querying

[Mudshark]

I appreciate, as always, the time people take to post answers to problems we are having...

In Access 2000:

I have a main form containing several sub-forms (one to many relationship). I want to query on a value found in one of the sub-forms and then display that record which meets my query - which would involve updating the main form and all of it's sub-forms....

Do I have to define overall form on a view (i.e. query) instead of the main table? How do you "back-track update" from a subform record to the main form which displays the subform?

thanks in advance for taking the time.

Mudshark

 

[yotwiggy]

My way of handling this issue was to create a form with comboboxes for fields that a user may wish to search by. When they narrow the search and select that record. Which will allow you to use the value of a record identifier in requerying your master display form.