Single Macro Error

[qzx999]

I am begging for some help here! I am looking for a solution that I can use on an Access 2010 form that I added a closeWindow button to. If I try and use the closeWindow button when all required fields are not complete then it will pop-up with the error messages telling me to complete required fields, but when I attempt to return to the form I get an additional pop-up with the "Single Step Macro" error window where I have to click "Stop all Macros".

I am looking for a way where I can keep the required fields error boxes, but not have that additional "Single Step Macro" error box pop-up.

Screenshot attached

 

[rzw0wr]

Try changing the Macro to VBA.

DoCmd.Close acForm, "FormNameHere", acSaveYes

You can and will need to add some error handling.

Use the quotes around your form name.
Dale

 

[qzx999]

I've tried to convert it to VBA but the problem persists. What type of error handling would you suggest? The challenge is that I want to keep the initial required field errors, but eliminate just this "Single Step Macro" error.