Afterupdate -

[andy]

Hi

I have set up an automatic logging feature in my database, which copies all
the record's details to "tblLogging", as a part of the forms AfterUpdate
process. It works great, however - the afterupdate feature is called
whenever you navigate through the records, meaning that the log table builds
up very quickly. The data is being sent to the log table even though
nothing is being physically updated.

I thought of using the onDirty event to flag if the form has changed, - do
you think this will work?

Have you got any other ideas of how to do this?

Thank you

AL

 

[Eric Butts]

Hi,

The AfterUpdate event occurs after changed data in a control or record is
updated.
(source: Microsoft Access help topic "AfterUpdate")

You must have something in your application that is updating the records as
you navigate to them.

Example, you could have something in your OnCurrent event that maybe
changing a value in a control.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support