One of my old databases written in access 2003, which I am resurrecting and updating, has developed a rather novel bug which even with a breakpoint on the error trap isn't showing up as to what's causing it.

On forms with a close form button, generated by the wizard, when the button is clicked the whole database shuts down.

all that is in the click event is the standard text that's generated by the command button wizard:

Private Sub cmdcloseform_Click()
On Error GoTo Err_cmdcloseform_Click

    DoCmd.Close

Exit_cmdcloseform_Click:
    Exit Sub

Err_cmdcloseform_Click:
    MsgBox Err.Description
    Resume Exit_cmdcloseform_Click

End Sub

Any help as to what is causing it would be grateful. I can stop it with making it deambiguous so that's not the real issue. Its what is causing it and why.

Hi, Jeremy. Instead of DoCmd.Close it's doing a DoCmd.Quit! Interesting. Have you tried entering the rest of the parameters after the close method to be specific? For example,

DoCmd.Close acForm, "Your Form Name", acSaveNo


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

hi serrano,

yeah that's what i meant by:

 "I can stop it with making it deambiguous so that's not the real issue"

Hmmmm... OK, how about Plan B?

Open an totally new database and import everything from your quirky one into this one. Then recompile the VBA code in the new one and try it again. It could be a form of corruption in your original that is triggering the shutdown.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division