Choosing the correct event

[George]

Good Day All,



I have a problem determining which event to use in a particular situation, or whether an event should be used at all.

Essentially, I want an action perform or not perform when I press a close button or exit button. I want the action performed if a record on the form is changed but nothing to happen if there is no change in the record.

Does anyone know how to proceed in this situation?

Thanks in advance.

[pbaldy]

Well, if you want it behind the button you can test:

If Me.Dirty Then

which will be true if the data has changed. Typically the before update event is used for validation.

[George]

hi Pbaldy, thanks for your guidance. I do want it behind the button. I applied the guidance; It worked and I am happy.

[pbaldy]

Happy to help!