Insert date after choosing from drop down list

[brucewalker]

I have a combo box in a form to choose from a drop down list. When a valus is chosen from the drop down list I want to insert the date into another field on the form. How can I do this? Thanks.:banghead:

 

[pr2-eugin]

Use the ComboBox After Update Property.. I have no idea what your fielnames are.. so in a wild guess.

Private Sub [COLOR=Blue]comboBoxName[/COLOR]_AfterUpdate()
    Me.[COLOR=Blue]FieldWhoseValueNeedsToBeSet[/COLOR] = Me.[COLOR=Blue]comboBoxName[/COLOR] ' If you want to put the value of the combo box in the field
    Me.[COLOR=Blue]FieldWhoseValueNeedsToBeSet[/COLOR] = Date ' If you want to put the Date
End Sub

Highlighted bits needs to changed based on your form names and design.