But if i put it on the next line this:

MsgBox "If a field is not filled in please enter N/A. This Record will not be saved", vbExclamation

happens regradless of whether a field is filled in or not. I don;t want that to happen!