Pop up message when selecting a specific option in combo box

  • Thread starter Thread starter SylvieB
  • Start date Start date
S

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.
 
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.
 
Back
Top