Multiple users overwriting records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my database, I have a txtName field that pulls your nt login and adds the
name to the table when you click on the "save record" button. If Bob
accidentally presses save record on Susie's record, it overwrites with his
name instead of Susie. How can I prevent this?
 
I would just make the default value of that field the code that you use to
get the nt login name. I also would have a date field what used =Now() to
capture when the record was created.

I would then take away the save name from the Save button OR put the name in
a new field named LastModifyRecord so that you could track who first created
it and who last modified the record.
 
Back
Top