Find and Replace in Subforms

S

Steve Jones

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?
 
M

ManningFan

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

John Vinson

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