auto populate a date when clicking on another field

Prayder

Registered User.
Local time
Today, 18:11
Joined
Mar 20, 2013
Messages
303
I would like a date field I have set up to auto populate the current date when I click on another field to enter information.. how would I do that?
 
I would like a date field I have set up to auto populate the current date when I click on another field to enter information.. how would I do that?

Is this on a form?
 
Yes it is on a form, so there are multiple rows with the same field info, and I am only wanting to update on record on the form otherwise I would use the default value for =Date()
 
Basically, if you're familiar with VBA, then you will just pick an Event for the control you are "clicking on" and when that Event occurs then set the other control = today's date. If you aren't familiar with Events let me know.

For example:

Code:
Private Sub ClickedControl_AfterUpdate()
DateControl.Value = Today()

Not sure if =Today() will work, so you may need to find a different function.
 
That worked... I didnt even think about using the value element of that field... thx.
 

Users who are viewing this thread

Back
Top Bottom