How do I insert the current username into a field?

[gedeon]

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.

 

[Rick B]

=CurrentUser()

 

[Rick Brandt]

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.

CurrentUser()

 

[TC]

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