[AccessD] Audit trail A97?

http://www.rogersaccesslibrary.com/download3.asp?SampleName=AuditTrail2.mdb

...I used this to build my own version ...hth.

William Hindman

----- Original Message ----- 
From: "Mark A Matte" <markamatte at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Friday, December 29, 2006 3:31 PM
Subject: [AccessD] Audit trail A97?


> Hello All,
>
> I have a subform (continuous)...it has about 5 fields...3 are editable.  I
> want to 'do something'(generate record in other table about what fields 
> were
> changed) each time they leave a record.  I don't want it to fire each time
> they edit a field...I would like it to fire when they are done with the
> entire record.  An audit trail of sorts.
>
> Any ideas/suggestions?
>
> Thanks,
>
> Mark A. Matte
>
> P.S...I thought I could use the DIRTY property...googled it...didn't find
> what I needed...but did find a nice article by Susan H.
> http://articles.techrepublic.com.com/5100-10877-6135056.html
>
> _________________________________________________________________
> Fixing up the home? Live Search can help
> http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmemailtaglinenov06&FORM=WLMTAG
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>