Searching using a subform

J

Jeannie

I have a parent form that has contact information like
name, phone number ect...I search the parent form by
placing the cursor in the field that I want to search by
and clicking the search button. I have a subform
connected to the main form that has additional contact
information like langues spoken, medical alerts ect...

The problem is, I cannot search using the subform fields.
If for example, I wanted to find a contact that spoke
Chinese I would like to place my cursor in that field,
click the search button,put chinese in the search criteria
to return the contacts.

How can I do this?

Jean
 
J

John R. Youngman

Jeannie,

To the best of my knowledge you cannot search on the subform fields. They
only "see" the data that is tied to the main form.

If you find a solution for this please let me know.

GL

John
 
Top