Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

propulating a text box with an automatic date and user

Status
Not open for further replies.

Cage

MIS
Aug 25, 2002
50
0
0
CA
I have a form which I want to have a 'last updated' textbox which is populated using a field from a table. Does anyone know how I can automatically update the textbox everytime someone uses the form to update a record. Ideally I want to be able to tell the last person and date every specific record was updated.

TIA

Cage
 
Set the form's AfterUpdate event to:

Me![FieldName] = Now() & Environ("UserName")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top