Before and after event for a query???

[StellaIndigo]

I have a query which needs to execute some VBA before and after the query runs.

I can't find an event for the query like Before or After.

Can I do this?



There are 10 types of people in the world. Those that understand binary and those that don't.

 

[lupins46]

Queries do not have events.

You could run your query from a button on a form and add the extra code that you want to run around the code created by the button wizard.

 

[StellaIndigo]

ok thanks Lupins

I couldn't find anything about events for queries. Didn't know if it was one of those hard to find or little documented feature.



There are 10 types of people in the world. Those that understand binary and those that don't.