Access 2010 record change event

Hi

I am using Access 2010 (continuous form)

What is the best way to catch a record change (record was pre-existing).

I would like to trap only events where the existing record actually  changed in some way.

Thanks
peispudAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
also, see sample codes from this link

How to create an audit trail of record changes in a form

http://support.microsoft.com/?kbid=197592
0
 
Rey Obrero (Capricorn1)Commented:
look for On Dirty event of the form from help
0
 
peispudAuthor Commented:
The On Dirty event  gets triggered even if the user exits without changing the data.  For example,  if the user hits the escape key or undo button,  the OnDirty event still triggers.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Use the Form Dirty event.  This event will trigger as soon as any Bound control value is changed in either a New or existing record.

dirty
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"The On Dirty event  gets triggered even if the user exits without changing the data. "
Actually it doesn't.  If this is, then something is wrong ... something else is going on.

mx
0
 
peispudAuthor Commented:
Thank you
0
All Courses

From novice to tech pro — start learning today.