Hi, I am opening the print preview from form and I would like to know when user closes the preview so I can close the form window from VBA. Is it possible to somehow check when the Preview is closed? Thank you
Hi, I am opening the print preview from form and I would like to know when user closes the preview so I can close the form window from VBA. Is it possible to somehow check when the Preview is closed? Thank you
Hi, I am opening the print preview from form and I would like to know when user closes the preview so I can close the form window from VBA. Is it possible to somehow check when the Preview is closed? Thank you
My advice would be to approach these types of situations by simply disabling the red X (close) button on the form and explicitly coding a command button, both to open in print preview as well as close - that way you're in control and can do everything needed in the button's click event, rather than having to hook into events. However, I've never tried to "print preview a form" before so that's about the only advice I can give.
Good luck!