Display current time as a text in a form when a combo box is updated

[gwaipor]

I have a form with a combo box. I would like the current date and time to be displayed on the form next to the combo box when the combo box is selected and updated.

[ssanfu]

Welcome to the forum.....

I would like the current date and time to be displayed on the form next to the combo box when the combo box is selected and updated.

Sounds simple, but ......

OK, the simple part:
In the afterupdate event of the combo box, you would have something like this:

Sub Combobox_AfterUpdate()
     Me.TextBoxName = Now()
End Sub

Change "TextBoxName" to your text box name.
(I don't have Access on this computer, so I can't text the code)

Now the question is: Do you want to save the date and time?
If yes, then the text box must be bound to a field in the recordset.


Another question:
If there is a date/time in the text box, do you want the date/time to change if a different selection is made from the combo box?
If you do not want the original Date/time to change, you will have to add code to prevent the date/time change.