[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 863
  • Last Modified:

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
0
peispud
Asked:
peispud
  • 2
  • 2
  • 2
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
Rey Obrero (Capricorn1)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
 
peispudAuthor Commented:
Thank you
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now