Identify when controls have been modified

[bmc1234]

I have a form with about 40 controls on it in the form of text boxes, combo boxes, and check boxes. In the afterupdate event of the form I want to identify which fields have been changed and write the new values of those fields to a table that keeps track of changes. I don't want to have to put code in the afterupdate event of every control. Is there any way to identify whether a particular control has been modified? I figure it would be something like the Dirty property, but that is only valid for the record as a whole, not individual fields.

 

[BobRodes]

This is an Access question. VB Forms don't have an AfterUpdate event, since forms aren't assumed to be bound to data. However, here's a link

http://msdn.microsoft.com/library/d...en-us/off2000/html/acevtBeforeAfterUpdate.asp

Check out the section on the OldValue property of bound controls. If that doesn't solve your problem, perhaps you'll want to repost to the correct forum. If you do this, then say so on this thread.

HTH

Bob

 

[bmc1234]

I have reposted this question here:

http://www.tek-tips.com/viewthread.cfm?qid=1101929&page=1