Run macro upon close of table or query

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

Is there a way to get a macro (M01_UpdateAllTables) to run automatically when
a query (Q01_ReviewData) is closed?
 
If you run the query via a macro or VB prodecure, just run your macro next in
line. Otherwise, I don't think its possible.
It's best to tell us what you are tring to achieve so we can suggest the
best solution.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Is there a way to get a macro (M01_UpdateAllTables) to run automatically when
a query (Q01_ReviewData) is closed?
Click to expand...

Note that query datasheets are NOT really appropriate for presenting data to
users, and that they also have no usable events. Consider presenting your
ReviewData query to the user on a Form, and using the form's Close event to
run UpdateAllTables.
 
Back
Top