Date stamp a combo box selection

A

al.redeye

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

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

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...
 

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

Similar Threads

If/Then Combo? 5
POPULATE a textbox based on combo box selection 3
return value based on combo box selection 3
Creating custom stamps in .pdf Adobe documents 1
Date/Time Stamp with check box 8
How do I add a COLUMN to combo box 2
Auto-populate fields with combo box AND date range 9
Date Stamp Only When *Field* Changes, not Whenever *Record* Change 4

Top