Required Field Error

[Noah114]

I have a form that through control boxes established values for the assigned table. I have set 'required' in the table properties for each field. The problem I am running into is if I start entering data into the form, and then just wish to exit without saving, I get an error mandating the required field. How can I set the form simply to close and not saved what was done?

 

[Remou]

You need to undo the record before exiting. For example:

If Me.Dirty Then
  If Msgox("Save?",vbYesNo)=vbNo Then
     Me.Undo
  Else
     If IsNull(me.txtRequired) Then
        MsgBox "Please complete"
     End If
  End If
End If