View Single Post
Old 01-22-2018, 08:17 AM   #15
CraigDouglas
Newly Registered User
 
Join Date: Sep 2016
Posts: 16
Thanks: 2
Thanked 0 Times in 0 Posts
CraigDouglas is on a distinguished road
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?

Sincerely
Craig
CraigDouglas is offline   Reply With Quote