Select All Subform Records

  • Thread starter Thread starter Connell Giacomini
  • Start date Start date
C

Connell Giacomini

My subform has a command button which runs macros to update several fields.
However it only operates on the first selected record in the subform. Is
there a macro command that can select all of the subform records, then run
the other macros?
 
My subform has a command button which runs macros to update several fields.
However it only operates on the first selected record in the subform. Is
there a macro command that can select all of the subform records, then run
the other macros?
Click to expand...

Since data is stored in Tables, not in Subforms, you'll need to run an Update
Query to update the *table* underlying the form. It should have appropriate
criteria to select just those records displayed on the form.
 
Back
Top