Linking date field to text field entry

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?
 
D

Darren

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top