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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top