In macro: Run query after previous table is closed

  • Thread starter Thread starter Jennifer
  • Start date Start date
J

Jennifer

In a macro that I run I open a table for the user to add in a new name into a
table and then when that is closed I need to run the rest of the macro. How
do I do this?
 
Jennifer,

I recommend that you do not allow users access to tables. Ever! The
purpose of tables is data storage. Use a form for the entry or editing
or viewing of data.

And if you use a form, you can use the Close event of the form to run
the subsequent actions in a separate macro. Or alternatively you can
open the form in Dialog mode (popup), which means the macro will be
suspended until the form is closed.
 
Back
Top