Re: Run Yes/No MessageBox from MACRO
Dear Access Junkie
Please, can you help me? I am using Access 2007. I want to use a macro. If a certain field IsNull I want a message to pop up and ask a question and then I want it so you can chose Yes No or Cancel or even just Yes No. The fields name is [EmailAddress] the question would be "Are you sure you want to close the form without an email address?" If Yes is chosen then I want the form to close and if No is chosen I want the form to stay open so that an email address can be added. Would I put the macro in the On Close form event?