In macro: Run query after previous table is closed

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

Steve Schapel

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.
 

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

Similar Threads

Compact & Repair, Open table, close table, then run macro 3
Cancel Macro If Table is empty. 5
Run a macro after a table is updated.... 3
VBA - retrieve data on last create named range from previous inserted named range 0
Run a macro and pause before running second macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
how to run a query upon a form closing 1
Repeat macro until record count of query = 0 0

Top