How Do I Capture User info In a Form

[shadows]

Hi Guys,
I have a small problem, hope you can help me out. I have created a a form in Access for data entry. But I would like the form to capture the data and time and the user who's entering the data into the form.
How do I do that. Been trying to figure it out . Hope you can help. Attached is the screenshot of the form I created. Thanks a bunch

 

[Laurentech]

One way to achieve this: in the form's On Dirty event put the following:

Me.UpdatedDate = Date
Me.UpdatedUser = Application.CurrentUser

This way, anytime a user types anything on the form (makes it dirty) the two fields will be updated. If the user is just scrolling through the records, the fileds will not be changed.

Larry

 

[shadows]

hey thanks larry... will try it out now

 

[shadows]

hi larry,
i'm not too sure what you ment by "On Dirty" event? is it that i right click on the properties in the text box? please guide. highly appreciated. thanks.

One way to achieve this: in the form's On Dirty event put the following:

Me.UpdatedDate = Date
Me.UpdatedUser = Application.CurrentUser

This way, anytime a user types anything on the form (makes it dirty) the two fields will be updated. If the user is just scrolling through the records, the fileds will not be changed.

Larry