I have been trying to run this code:
Private Sub FName_Exit(Cancel As Integer)
If IsNull(Me!FName) Then
MsgBox "Eh...fill this in!"
But every time it changes to the next field on the form on Access 2007
I can't seem to get it to stay on that field. I just want it to make sure the field is not null or empty. Actually I want to have the button I have setup to check then entire form for this...the button is the Add Record/Save but can't figure out how to do this...