opening multiple items with one button

[dj_chunky2002]

I'm using access. i have a combo box on a form with a list of hyperlinked items, but i want a button to open the selected item. how can i do this?

 

[Bodisathva]

place the particular DoCmd.Open code in the On_Change event of the combo box... use the current selection of the combo box to determine what exactly you need to open

 

[dj_chunky2002]

couldn't go into a bit more detail could you? an example maybe? i'm very new to this! lol

 

[Bodisathva]

couldn't go into a bit more detail could you? an example maybe? i'm very new to this! lol

in your form:

Private Sub Combo0_Change()
    Select Case Me.Combo0
        Case 1
               Do this...
               DoCmd.OpenForm "myFormName"
               DoCmd.OpenForm "myOtherFormName"
        Case 2
               DoCmd.OpenReport "thisReport",acViewPreview  
               DoCmd.OpenReport "thisOtherReport",acViewPreview  
                .
                .
                .
        Case Else
               DoCmd.HokeyPokey
               DoCmd.TurnAround
    End Select
End Sub