Question General Question - "on date required"

[nyrob609]

I have a database that will be use by many to keep information. But I want to make sure that the person creating a new record makes sure the old record has a termination date enter. I want them to use new record command button but I want to cancel the event if the statement is true [termination date] is null, Msg. "Please make sure termination date is enter" and go to the control source. But I want all this to happen before going to a new record. Every time I click the button it gives me the message and then it goes to the control field but it is the new record not the old.

 

[HiTechCoach]

What VBA code are you currently using?