Running a macro from a query

[HEMASUR]

Is it possible to run a macro on closing of a query.
I have an append query, on close I need to run an update query.
Thanking you.

Hema

 

[dhookom]

Won't happen. Many of us would write some code to run the append query and then run more code.

Duane
Hook'D on Access
MS Access MVP

 

[HEMASUR]

Thank you!
Was hoping to make life a little bit easier.......

 

[MCuthill]

HEMASUR,

Perhaps I am misunderstanding the question... but several queries can be tied to a single macro. If the update query runs immediately following the append query, create a new macro, with the action "OpenQuery" tied to your Append Query then on the second line of the macro, do another "OpenQuery" action tied to your Update Query.

I usually put a "MsgBox" Action at the end with a "Job Done" message to notify the macro has finished running.

Hope this helps.

Mike
___________________________
There Are 10 Types of People,
Those Who Can Read Binary...
And Those Who Can't.

 

[HEMASUR]

Thanks Mike,
That's the way I have it now.