Drop Down List

[fenhow]

Hi,

Is it possible to activate something when a particular item is selected in a Dropdown list?

Say I have 1,2,3

If user selects 1, something happens, if they select 2, something else happens and so on.

Thanks.
Fen How

 

[boblarson]

Yes, in the combo box's After Update event you can do something:

Private Sub YourComboNameHere_AfterUpdate()
   Select Case YourComboNameHere
      Case 1 ' open a report
          DoCmd.OpenReport "SomeReport", acViewPreview

      Case 2 ' open a form
          DoCmd.OpenForm "SomeForm"

       Case 3 ' Give a message box
           MsgBox "Hello"
    End Select
End Sub