Hello,

I have a form that I written an on close event procedure
for. part of the on close procedure is checking for a
possible error condition that may occur in the
application I have developed. If this error condition
occurs I want to either stop the form from closing or
reopen the form with the same record that is being used.  
When I add the code to reopen the form to the on close
event what is happening is that the form is not being
reopened when I test the error condition happening. I
would like to know if anyone has some ideas on how I can
reopen a form from within the forms on close event?

Thanks

Eric Lommatsch

Use the Unload event instead, Eric - it can be cancelled by setting the
Cancel argument to True.

--
Brendan Reynolds (MVP)