Drop Down List

fenhow

Registered User.
Local time
Today, 09:05
Joined
Jul 21, 2004
Messages
599
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
 
Yes, in the combo box's After Update event you can do something:

Code:
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
 

Users who are viewing this thread

Back
Top Bottom