Select All Subform Records

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

John W. Vinson

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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top