Hiya,
Basically I have 2 tables tblEmployee and tblDetails. My database is a
****pping database that tracks all the freight in the warehouse.
Records are added by the guys in the warehouse and then edited by
staff in the office, therefore there will be multiple users of this
database. Need to devise somesort of tracking which records which user
has edited the record and what changes he/she has made. I have found a
great example which you have to add a field in tblDetails and set it
to memo and then attach some code in the beforeupdate event in the
form. This works really well but when you make amendments to the
record it always says user: Admin. How do you set up multiple users so
that it might say User: Warehouse, or User: Gemma etc...?
Fiona
