Pop up message when selecting a specific option in combo box SylvieB 11/10/2008 4:31:03 PM 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.

Re: Pop up message when selecting a specific option in combo box "ruralguy via AccessMonster.com" <u12102[ at ]uwe> 11/10/2008 5:42:05 PM 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. SylvieB wrote: [Quoted Text] >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 (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com

RE: Pop up message when selecting a specific option in combo box Beetle 11/10/2008 5:49:01 PM 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. -- _________ Sean Bailey "SylvieB" wrote: [Quoted Text] > 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. >