Recording changes

[Jason]

I have a form and I'd like to know what changes were made
to previously saved records. In order to edit records, the
user has to press an unlock button (to prevent accidental
edits.) Is there some way that I can write the changes
that are made to a table to maintain history? I think
maybe the On Dirty event?

All help is appreciated...Thanks in advance!

Jason

 

[Gary Miller]

Jason,

I would think that the OnDirty even would be too early as
that occurs just as the first Edit is being made. I would
suggest either the Before or AfterUpdate events using a
recordset method to populate the second history table.

Gary Miller
Sisters, OR