Date in text box

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

Guest

Currently, I'm created a form with this field, "Updated by".

If I wld like today's date to appear in the textbox,"updated by" How do I go
abt doing it???

Thank you for all the help!!!!
 
Use the BeforeUpdate event procedure of the form to put the date in the
field:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[Updated By] = Date
End Sub

Use Now() instead of Date if you want the time as well as the date.
 
Back
Top