The Cancel Button

[StacyStacy]

How do I clear all transactions, even edit checks from all fields on a form when the "cancel" or "find" button is clicked?

Thanks,

 

[Rich]

Me.Undo ?

 

[StacyStacy]

It doesn't work. Here's the error message:

… the field ‘COURSE NUMBER.COURSE_CODE’ cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.

I don't want he end user to have to enter bogus info. Here's my code on my cancel button:

Private Sub CANCEL_CHANGES_IN_CREATE_MODIFY_PROGRAM_AND_CODES_Click()

If Me.Dirty Then
Me.Undo
Cancel = True
Refresh
End If

End Sub

********************************************
On "lost focus"

If Me.Dirty Then
Me.Undo
Cancel = True
End If

 

[StacyStacy]

Does Anyone Know?

This is my last try: Does anyone know how to resolve this issue?

Thanks,