Writing a record to a table.
Posted on 2016-09-20
I have a bunch of tables with various bits of information and status updates on them but what I want to do is create a table called tbl_StatusUpdates and need some help writing the code to record the update of a status.
For example on Form 1 I have one field called Status.
Every time someone updates this field, I want in the tbl_status table to record, the name of the status, the date the record was updated and the Environ("User") of the person.
I think it should be pretty easy but I'm not sure how to go to table create a new record and then add these three pieces of data, any ideas?