Murray Brown
asked on
Access Record Edits in form
Hi
I have an Access form were the RecordSource is a table called "t_Licence". If the user edits any field I want to keep a record of what the field was before and after. What events and VBA code would I use to do this?
I have an Access form were the RecordSource is a table called "t_Licence". If the user edits any field I want to keep a record of what the field was before and after. What events and VBA code would I use to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<grin>
IF and it is a big if, you’ve built some fairly secure forms already, then staging data might be more work. If you’ ve got loosey-goosey forms, it might be less. Much too depends on how rigorous the data auditing needs to be
ASKER
Thanks very much for the advice
If all you're after is (a) what the data state was before the change and (b) what the data state is after the change, then the audit log methods suggested would suffice. Using temp-bound forms for situations like this is just overkill.