Find and Replace in Subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
How can the users run a Find
for a subform field that includes all of the records in the database?
Click to expand...

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]
 
Back
Top