Message box on selection of value

[Sgt Bilkp]

Hi all...

Looking for a bit of assistance with a message/pop-up box. On one of my forms i have a combo box that takes its values from another table. On selection of a certain option (3) i would like a message box to appear to offer the user a reminder. Any suggestions are greatly appreciated.

 

[maxmangion]

you can try putting something on the AfterUpdate event of your combo such as the following:

If Me.ComboName = "value here" Then
Msgbox "message goes here"
End If

Replace ComboName with the name of your Combo Box.

 

[Sgt Bilkp]

Once again, the speed and quality of replies is tip top. Thank you for being so helpful.

 

[maxmangion]

you're very welcome