VBA Check for change in record (1 Viewer)

[marrett]

I want to check a form to see if the user has made any changes. This Chaeck has to take place when a cancel button or save button is pressed. I dont want the user to be propted if no changes have been made.


Thnaks,

Maria

 

[David R]

Look into the Dirty() property for Access2k. I think in earlier versions you have to use some checks within BeforeUpdate.

HTH,
David R

 

[marrett]

-Thanks it works great!

 

[The_Doc_Man]

Dirty also applies in AC97. It SURELY applies to the bound controls of a form. However, once an update occurs, all Dirty flags get reset. So the best time to check is in the Form_BeforeUpdate routine. Which so conveniently is the one that supports the Cancel parameter.