Find and Replace in Subforms

[Guest]

I have a database form with a subform that is working well, except when users
try to run the Find and Replace function from inside the subform. When they
run the Find command from inside the subform, the find only checks the fields
for the single record displayed at the time. How can the users run a Find
for a subform field that includes all of the records in the database?

 

[ManningFan]

Use the RecordSource property to display only those records that match
the find.

 

[John Vinson]

How can the users run a Find
for a subform field that includes all of the records in the database?

Probably by not running a Find and Replace at all.

Instead, run an Update Query (launched from code using criteria
provided on the form), that will update the Table. Bear in mind: the
form *doesn't contain any data* and you can't update "the form";
you're updateing a Table.

John W. Vinson[MVP]