Ignore Required Field on Close of Form

[mizenerman]

I have created a button that will allow the user to exit and close the form if necessary. The problem is that I have a required field that is being verified before the form is closed thus creating the user to enter an arbitrary value in the field then pressing the button again. The code for the field is:

Private Sub MRN_Exit(Cancel As Integer)
If IsNull(Me![MRN]) Then
Cancel = True
MsgBox " MRN is required."
Me![MRN].SetFocus
End If
End Sub

The code for the button is:

Private Sub Cancel_and_Exit_Click()
DoCmd.Quit acQuitSaveNone
End Sub

How do I get VB to ignore that required field when clicking the button? Any guidance is much appreciated.

Thank you!

 

[Remou]

Access will automatically save a record; 'acQuitSaveNone' refers to objects, not records; you need an Undo for the reord. If you have subforms, this may not be possible and you will need to look at other methods.

 

[PHV]

Perhaps this ?
Private Sub Cancel_and_Exit_Click()
If Me.Dirty Then Me.Undo
DoCmd.Quit acQuitSaveNone
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886