How do I insert the current username into a field?

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

Guest

I have a db with user-level security. I want to store the current username of
who modified a record using OnDirty, but don't know where to find it.
 
gedeon said:
I have a db with user-level security. I want to store the current
username of who modified a record using OnDirty, but don't know where
to find it.
Click to expand...

CurrentUser()
 
OnDirty is not the right event. What if they dirty the record but then
press Esc to discard their change?

I suggest you use BeforeUpdate. That event is fired when the record is
dirty /and/ the user has asked Access to actually save the change.

HTH,
TC
 
Back
Top