Pop-up In MS Access

Hi,

I’m creating a form in MS Access.  I have a drop down list for:
Y = Yes
N = No
U = Unknown.

Is there a way that if “N” is selected a pop-up message will appear?

Thanks in advance.
ReyesrjAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Well, that was just a quick example ...

Can you upload your db ?

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:


Private Sub YourComboBoxName_AfterUpdate()

If me.YourComboBoxName = "N" then
    msgbox "Your Message here"
End If

End Sub

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
See image
Capture1.gif
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ReyesrjAuthor Commented:
I could not get it to work.
The choice list is from a table.  Also, I notice that you have "Unbound" in the choice box.
0
 
ReyesrjAuthor Commented:
I had a typo.

IT WORKED!!!

Thanks!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
COOL !!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.