to Undo, or not to Undo...

[Davince]

I've got a form in an access 2007 Db that I've put a 'save & close' button on, which in a Macro checks to see if you've entered data correctly before it saves, if you haven't it brings up a message box that says 'data missing, record will not be saved, are you sure you want to exit' - if you click 'no' it takes you back to the form to carry on, if you click 'yes', I had it set to 'Undo' then 'close' - to make sure half finished / improper records weren't created.

That works fine... if you've started entering data. But if you hit 'save and close' without actually entering any data into any field at all - it closes down, but it brings up an error saying 'Undo not available at this time' AFTER it's closed the form.



Sooooo... is there a neater solution? or a way of making the macro check to see if there has been any entry?

[June7]

Is this macro or VBA?

Check if the form IsDirty before executing Undo.

[Davince]

Thanks June sorted!