onclose event fires when filteron

[sozzer]

I'd be grateful if anyone knows whether a report onclose event is supposed to fire when i apply a filter to a report using vba. My code opens a report and then applies a filter using whatever criteria a user input into a form. But whenever it does this, the onclose event seems to fire, opening a modal form and making the report inaccessible. it's driving me nuts trying to think of a way round this - help!

many thanks

 

[Lightning]

Why not apply the Filter to the report's Recordsource, and then open the report?

HTH
Lightning

 

[ZmrAbdulla]

duplicate post thread702-1037143

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.