Fill text box based on combo box selection

S

Scott

Hello-

I have a form called frmInquiries. There is a combo box called
cboInqStatus and a text box called txtResolveDate. The two values in
the combo box are "Active" and "Completed". >What I want to do is to
have txtResolveDate filled with the current date once the user changes
the combo box from "Active" to "Completed". Any ideas on this? Thanks
in advance for the help.
 
S

Scott

I think I figured this out with the following code in the After Update
event of the combo box:

Private Sub InquiryStatus_AfterUpdate()
If InquiryStatus = "Completed" Then
Me.ResolveDate = Date
Else
Me.ResolveDate = Null
End If
End Sub
 

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

sum combo box based on other combo box 2
combo box selection will not populate query correctly 1
filter on combo box possible? 1
combo box selection to auto fill a second combo box (or field) 1
Populate a text box from a combo box selection 2
Combo box help 1
Combo Box Selection is Blank 1
Filtering combo boxes based on a selection in another combo box 1

Top