OnClose

R

Rick

I'm assuming this is in a Report. What you can do is make
the OnClose function a Module and then delete
the "OnClose" function in the form. This will keep it
from firing when you try to edit a report.

Create the module and then to call it by typing this in
the OnClose function of the form:

= CloseForm()

CloseForm = the name of your module in the heading of the
function

Example:

Public Function CloseForm()

DoCmd.Close
DoeCmd.open "Form"

End Function

Hope this helps
 
Top