How to search for records with multiple subforms...

[diverjess]

Hello!

I have a large database with multiple tables. There a two central forms, both of which contain multiple subforms.

One form (EDIT) has a disabled txtID as well as a tab control with multiple tabs (i.e. "Names," "Contact Info," "Address" etc). Within each tab is a subform. Each subform has a hidden txtID that is linked to the parent (EDIT) form's txtID.

I really need to create a way to search for a specific record based on a name...and open that record's information in each tab as well as populate the txtID in the parent (EDIT) form based on the name.

However, some records have the same name but different sub-information, which means the search would have to filter out all names except those matching...then the user could scroll through only those few names.

Any ideas?!
Thanks in advance for helping out

 

[seaport]

Using a form filter is a good option. I cannot think any other way to do it.

Seaport

 

[diverjess]

So how can I create the filter?

 

[seaport]

The code would be like:

me.filteron=true
me.filter="[name]='" & txtFind & "'"


Seaport