Help needed with adding a record in a subform

[Rich Stone]

I have created a stock control database and have a form with which to
view/add/amend/delete single stock items. On another tab of the form, I have
a subform which displays an audit table. What I am trying to do is create an
entry in the audit table every time the stock record is updated, bearing in
mind that several changes may be made to the stock item without leaving the
form. What is the best way to do this?

 

[Allen Browne]

See:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html