Linking date field to text field entry

  • Thread starter Thread starter Trey
  • Start date Start date
T

Trey

Is there a way to setup a date field that will
automatically enter the date when any information is
entered into a field next to it?
 
Just as an example....
If you have field A and field B, A being the date field and named txtA,
field B is named txtB. Use the following code added to the AfterUpdate
event for B:

Private Sub txtB()
Me.txtA = Date
End Sub

Once you have added details to field B and pressed enter or clicked on
another field, field A will display and record the current date.

HTH
Darren
 
Back
Top