[AccessD] Audit trail A97?

Form BeforeUpdate or AfterUpdate event

Doris Manning
Database Administrator
Hargrove Inc.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Friday, December 29, 2006 3:31 PM
To: accessd at databaseadvisors.com
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=e
n-US&source=hmemailtaglinenov06&FORM=WLMTAG

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com