Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

popup form

Status
Not open for further replies.

is1ma1il

MIS
Feb 15, 2002
51
US
Hi,

On a form I have a combo box of Yes and No. When they choose No I want a popup form to appear. If they choose Yes nothing else happens.

Anyone?
 
Hi,

You'll need to attach some code to the afterupdate event of the combobox like this (substitute "yourcombobox" for the name of your combobox):

Private Sub yourcombobox_AfterUpdate()
If Me!yourcombobox = "no" Then MsgBox "your message here"
End Sub

That should do it.
 
I put this in and it is showing an error

If Me!yourcombobox = "no" Then DoCmd.OpenForm (Form1)

sorry for being a pain.
 
sorry have fixed it, stupid mistake.

Thanks for your help
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top