Run code each time the record changes

D

Dustin I.

Can anyone tell me how to run code each time the record
changes on a form? Maybe a form event that would execute
everytime I go forward or backword in a recordset.

Thanks
 
R

Ronald W. Roberts

Dustin said:
Can anyone tell me how to run code each time the record
changes on a form? Maybe a form event that would execute
everytime I go forward or backword in a recordset.

Thanks
Click to expand...
It all depends upon what you want to do. Look at using Me.Dirty in the
BeforeUpdate, AfterUpdate, BeforeInsert, AfterInsert events at the form
level.

If Me.Dirty
Do something
EndIf


Ron
 
Top