Adding 2 information pop boxes to a yes/no drop down list box. Any ideas? using vba?

[wedd]

I have a yes/no drop down list box. What i'm trying to do is whenever yes or no are selected a pop-up message will be dispalyed. I have access 2007. Do any of you experts know or have any sample code on how I can achieve this to work?


Thanks for your ideas:friends:

[Imdabaum]

Wedd,

Not to put a thorn in your side, but didn't we already go over this? Click the [...] button in the AfterUpdate event box for the drop down box properties. Then insert the code with exception to the afterupdate and end sub.


Sub AfterUpdate()
Call MsgBox("Prompt", messageType, "Title")
'Where messageType is the chosen type vbOKOnly, vbOKCancel, vbCritical,
'vbInformation, vbExclamation etc... you'll get autocomplete to give you
'the available choices
End Sub

[wedd]

Yes, I do remember but I didn't receive many responses..so I've been a bit more specific...I received repsonses that it couldn't be done..but I had a hunch that it could be done. Anyway, I knew someone or I would crack it...thanks again!

[Imdabaum]

You cannot do a Yes/No MsgBox from a macro, but from VBA you can do it.

[orange]

There is a great tutorial with examples dealing with forms and dialog boxes.
May not be exactly what you're looking for, but I'm sure you'll gain a lot of insight on the subject.
see http://www.fontstuff.com/access/acctut19.htm