Good Morning Rich,

     I have been trying to figure how to create a helpful error message prompt for missing information, in particular when mapping an address for a customer.

In my form currently I have a "click to map" button/marco that will open up to google maps and map the address information that is entered in the address section.

I have already created an error message form that states "address information is missing, please enter information and try again".

What I am struggling with is the coding in the VBA because I don't know it very well

I just want the code to check if the address information is present ...

if yes -> go and map it.

if no  -> stop "click to map" macro and start error message macro requesting user to double check address information.

Thank you in advance for your help.