enter current date when "complete" is chosen from a combo box

J

John Vinson

On Wed, 27 Apr 2005 15:17:36 -0700, MarcTA

If you have a question, it's considered polite to ask it in the text
area, not just the subject line; provide enough context that a
volunteer here can make a reasoned reply.

At a guess, you can use the Combo Box's AfterUpdate event. Invoke the
Code Builder by clicking the ... icon; put in code like

Private Sub combobox_AfterUpdate()
If Me!combobox = "Complete" Then
Me!txtDateComplete = Date ' or Now for date & time
End If
End Sub


John W. Vinson[MVP]
 

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

Using A Dlookup Function On A Form When A Combo Box is Updated 2
how to update a record from combo-box in user form? 0
I want a text box to appear only when a combo box is set 3
Combo Box selection returns a Date() in another field 7
combo box not visable on form when loaded from specific location 3
Get a Date to show as a Date Format in Combo Box 3
Removing Blank Entries From a Combo Box in a Form 1
Disable button if a combo box is blank 1

Top