close report, have macro start

[toddbingham]

I want to, when a report is closed, to have a macro start. How and where would I do this?

Thanks.

 

[Calvin]

with the report in design mode, insert the name of the macro into the OnClose or OnDeactivate event of the report properties.

When you place the curser in the properties a dropdown list will appear and the macro's name should be on the dropdown list.