Stop Macro if any required fields are blank

[coolcps]

I have macros that will close the current form and open another, but when there are required fields not filled in then problems arise. Is there anyway to first have the macro check to see that all required fields have a value, and if they do then continue on with the current process. If there are required fields with no values then the current form will stay open until it is completed. I know there is a Stop Macro macro, but I am not sure how to make it do what I want. Thanks for any help!

 

[khawar]

You can use vba to validate filelds first then if all fields are filled run the macro else
display message that all fields need to be filled

 

[coolcps]

Is there some code that would validate all required fields that I can use for multiple forms without changing the code to validate each individual field?

 

[khawar]

you have to validate each field

 

[gemma-the-husky]

cant you just have a function to test the validation

sort of

if not valid the stop/exit macro

i don't use macros, just code - but the principle must be the same