Current User (1 Viewer)

[Peter Paul]

I am developing a multi-user lost and found database to be used at a variety of terminals by lots o' folks. I am setting up permissions, and would like to automatically tag the current user onto an entry form. I have figured out how to display the current user, but not how to save it. The effect is that when a new user looks at the form, it updates that field to that users identifier.

Thanks
Peter

 

[Travis]

on the Form_Open or Form_Load

add the code:

Me.[FieldCurrentUser]= CurrentUser

If it could go record to record use the Form_Current