Bob Collison
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great solution. I have not previously used the Form Unload Event.
Glad I could help.
ASKER
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.