updating to a different table

  • Thread starter Thread starter Kelly Tyler
  • Start date Start date
K

Kelly Tyler

in a form -- on exit of a certain field how would you
update fields from a separate table?
For instance, if I had a form that update TableA
on update of one of those fields I would like to capture
UserName and DateChanged in TableB.

It seems like it would be easy but my limited
understanding of VBA, SQL and ADO is confusing the heck
out of me. Any ideas or examples would be greatly
appreciated.
 
Use the AfterUpdate event of the form to execute an Append query statement
to append the name and date to your table.

There is a much more comprehensive example of what you are asking for in
article:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html
It does illustrate how to create the query statement though.
 
Back
Top