How can I search a form and associated subforms at the same in Acc

[Drake]

Hello All,

I have a form with several subforms embedded in it and I need to be able to
use the Find function or some other search mechanism to be able to search
across the form and the subforms at the same time.

Any thoughts?

Drake

 

[John W. Vinson]

Hello All,

I have a form with several subforms embedded in it and I need to be able to
use the Find function or some other search mechanism to be able to search
across the form and the subforms at the same time.

Any thoughts?

Drake

First off... you can't search Forms because data isn't stored in Forms.
They're just windows, tools to let you view data stored in Tables. Any Query
will apply to a Table, or multiple tables, not to Forms.

Secondly, if you need to search a form and several subforms (or their tables)
for the same criterion, I'm dubious about your table design! What specifically
are you trying to do? What tables are these forms based upon, and what do you
want to search?