Close button on a form (access 2003)

Topic

New Reply

Hi all,

I have created a close form button on one of my access forms but when I click on the button I get the following error(see the attached file)
Many thanks for your help

Reply | Quote

Replies

Skender,

Did you use the wizard to create the button, or did you write the VBA yourself? Right click on the button, and go to properties. Go to the ‘event’ tab, and select the ‘on click’ event. Click the three dots to the right. It should look something like

Private Sub CloseButton_Click()
DoCmd.Close
End Sub

Reply | Quote

I did use the wizard and I also created the button manually and I still get the same problem.

Cheers

Reply | Quote

What is the code you used? You really only need 1 line of code behind the button:

DoCmd.Close

Reply | Quote

There was something wrong with the form I guess, I have created a new form and also the close button, all working fine now….

Cheers for your help.

Reply | Quote