Please help me regarding in Combo Box

how to link the combo box into the other forms

http://www.vbforums.com/

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

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

Code:

---

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

---

Thanks lot Thankyou very much

Your welcome :D

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