Please help me regarding in Combo Box

[lord_cedrich]

how to link the combo box into the other forms



may i know the code on how to link the combo box into the other form , example when i press pc2 the other pc2.frm form will be open ....there is a PC2 form everytime i choose in menu it will redirect me to the link form each of them has a form beginning in PC1-PC14.frm how can i make it to link me to the form i chose

Thanks a lot

[aikidokid]

I don't know if this is the best way, but try something like this:

Private Sub Combo1_Click

Select Case Combo1.Text
     Case Is = "PC2"
          frmPC2.Show
     Case Is = "PC3"
          frmPC3.Show

     'rest of forms here
End Select

End Sub

[lord_cedrich]

Thanks lot Thankyou very much

[aikidokid]

Your welcome

If it's now resolved could you use the Thread Tools menu to mark it resolved.