Combo Box

[mdr0906]

Hello,

I would like a message box to appear after a user selects the value" yes" from a drop down in a form. Any examples that you might be able to share?

Thanks.

mdr0906

 

[dkinley]

In the AfterUpdate() Event of the combo box ...


If Me!CombBoxName = "Yes" Then
MsgBox "You chose yes."
Else
(Optional) MsgBox "You chose something else."
End If

-dK

 

[mdr0906]

Thanks

Thanks for the prompt response!

 

[dkinley]

No problem -- it's heavy procrastination day.

Keep in mind that = "Yes" only works if the bound column of the combo box is the column that has the "Yes" in it. If not, you will need to adjust the logic to ...

Me!CombBoxName.Column(x) = "Yes"

where x is the number of the column with the "Yes" in it.

-dK