Find across subforms

[Guest]

Hi All,

I have a form with 2 subforms within it. I have set up a command button on
my main form which brings up the Find & Replace dialogue box as if the user
went "Ctrl F".

When using the FIND it seems to only search across my main form and not
across the subforms even if the look in field is set as the subform's name.

Is there any way to be able to set this so it will look across the main form
and the two subforms.

I am still only a beginner at Access and appreicate all the help I can get.

Thanks for your help in advance.
Janine

 

[John Vinson]

Hi All,

I have a form with 2 subforms within it. I have set up a command button on
my main form which brings up the Find & Replace dialogue box as if the user
went "Ctrl F".

When using the FIND it seems to only search across my main form and not
across the subforms even if the look in field is set as the subform's name.

Correct.

A Subform is not a field. It's a Form based on a Table, which could
potentially have tens of millions of records and 255 fields.

Which field would you expect to search?

Is there any way to be able to set this so it will look across the main form
and the two subforms.

I am still only a beginner at Access and appreicate all the help I can get.

Please explain the nature of the Tables involved (the mainform and the
two subforms' Recordsources), and what it is that you're trying to
search for. Since a Subform doesn't have "a value", using Ctrl-F to
search for a value "in a subform" really doesn't make any sense!

John W. Vinson[MVP]