A al.redeye Apr 2, 2008 #1 I'd like to insert an automatic date stamp in a text box when a particular selection is made in a combo box. Many thanks
I'd like to insert an automatic date stamp in a text box when a particular selection is made in a combo box. Many thanks
J John W. Vinson Apr 2, 2008 #2 I'd like to insert an automatic date stamp in a text box when a particular selection is made in a combo box. Many thanks Click to expand... Use some VBA code in the AfterUpdate event of the combo box, e.g. Private Sub mycombo_AfterUpdate() If Me!mycombo = "Particular Selection" Then Me!txttimestamp = Date ' or Now to store date and time End If End Sub
I'd like to insert an automatic date stamp in a text box when a particular selection is made in a combo box. Many thanks Click to expand... Use some VBA code in the AfterUpdate event of the combo box, e.g. Private Sub mycombo_AfterUpdate() If Me!mycombo = "Particular Selection" Then Me!txttimestamp = Date ' or Now to store date and time End If End Sub
A al.redeye Apr 3, 2008 #3 That worked a treat. Much appreciated John W. Vinson said: Use some VBA code in the AfterUpdate event of the combo box, e.g. Private Sub mycombo_AfterUpdate() If Me!mycombo = "Particular Selection" Then Me!txttimestamp = Date ' or Now to store date and time End If End Sub Click to expand...
That worked a treat. Much appreciated John W. Vinson said: Use some VBA code in the AfterUpdate event of the combo box, e.g. Private Sub mycombo_AfterUpdate() If Me!mycombo = "Particular Selection" Then Me!txttimestamp = Date ' or Now to store date and time End If End Sub Click to expand...
