auto populate a date when clicking on another field

[Prayder]

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?

 

[maw230]

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?

 

[Prayder]

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()

 

[maw230]

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:

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

Not sure if =Today() will work, so you may need to find a different function.

 

[Prayder]

That worked... I didnt even think about using the value element of that field... thx.

 

[maw230]

That worked... I didnt even think about using the value element of that field... thx.

Happy to help.