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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Three different fields in one record referencing to three different records in another table 1
Update with SQL 3
Filtering on a field in a table that the form is not based on 4
Using a combo box to change a foreign key relationship... 4
I need to return the yes/no value in a table 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Data entry for a table from a form 1
sql problem with updating data from a gridview 5

Back
Top