Link to home
Start Free TrialLog in
Avatar of Bob Collison
Bob CollisonFlag for Canada

asked on

MS Access 2010 Close Form Event - Stop Form Closing

Hi Experts,

I have code to detect if Child Forms are open for a Parent Form.

I want to be able to stop the Parent Form from closing if this is the case.

How can I do this?

Thanks,
Bob C.
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bob Collison

ASKER

Hi Dale,

The Child Form is a separate unique form opened from a form that is a Menu.  Data in the Menu is referenced in the Child Form, hence the reason for not closing the Menu while the Child Form is open.

I have tried the Form Unload Event and it works perfectly.

Thanks for the solution.
Bob C.
Great solution.  I have not previously used the Form Unload Event.
Glad I could help.