When a value is selcted open a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a drop down values and when I select "Other", I want it to
open another form. Does anyine know how to do this? Thanks in advance for any
help.
 
JAC said:
I have a form with a drop down values and when I select "Other", I
want it to open another form. Does anyine know how to do this? Thanks
in advance for any help.
Click to expand...

You don't give many details, but this might serve as a model for the
combo box's AfterUpdate event procedure:

'----- start of example code -----
Private Sub cboMyCombo_AfterUpdate()

If Me.cboMyCombo = "Other" Then
DoCmd.OpenForm "SomeForm"
End If

End Sub
'----- end of example code -----
 
Back
Top