Fill text box based on combo box selection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 10 Dec 2005 08:03 GMT

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.

Reply to this Message

Scott - 10 Dec 2005 08:30 GMT

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

Reply to this Message