Opening forms from selected options of combo box

[Mohammadsharif]

i want to open forms based on combo box selection

[ranman256]

I have a table, in it is the caption and table/queries users can pick from.
User picks a table/ and this button code opens it. But you'll notice, all my forms start with f,
reports; r, ...

Select Case LCase(Left(cboTbl, 1))
   Case "f"
     DoCmd.OpenForm cboTbl
   Case "q"
     DoCmd.OpenQuery cboTbl
   Case "t"
     DoCmd.OpenTable cboTbl
   Case "m"
     DoCmd.runMacro cboTbl
   Case "r"
     DoCmd.OpenReport cboTbl, acViewPreview
End Select

[Mohammadsharif]

thanx its solved