Run macro upon close of table or query

[GD]

Is there a way to get a macro (M01_UpdateAllTables) to run automatically when
a query (Q01_ReviewData) is closed?

 

[Dorian]

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".

 

[John W. Vinson]

Is there a way to get a macro (M01_UpdateAllTables) to run automatically when
a query (Q01_ReviewData) is closed?

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.