Pop up message when selecting a specific option in combo box

[SylvieB]

Hi
I need help with the following. I have a combo box in a form with 3 options
to choose from: Open, Closed, Parts on order. I want to display a pop up
message only when "Closed" option is selected. How do I do that?
Thanks a lot for any help you can provide.

 

[ruralguy via AccessMonster.com]

Use the AfterUpdate event of the ComboBox to check the selection and present
your pop up message. Actually, depending on the message, you may want to use
the BeforeUpdate event so you can cancel the selection.

 

[Beetle]

In the After Update event of your combo box;

Private Sub YourCombo_AfterUpdate()

If Me!YourComboBox = "Closed" Then
MsgBox "Your message here"
End If

End Sub

You'll need to use the actual name of your combo box in the above and
I have assumed that Open, Closed, etc are in the bound column of your
combo box.