Enable 2 objects in a Combo Box

[SeRene]

Hi,

I'm able to list both tables and forms in a single combo
box. However, I have no idea how to "tell" the system to
recognise which item is a table and which item is a form.
Therefore, an error msg like, "Item cannot be found" will
appear.

Therefore, when the user selects tbl1 frm the combo box,
wat can i do to "direct" the user to tbl1 and when the
user selects frm1 frm the same combo box, how can
i "direct" the user to frm1??

Need help badly on this!!
Thanks.

 

[Arvin Meyer]

Sub MyCombo_AfterUpdate()
If Left(Me.MyCombo, 3) = "tbl" Then
' it's a table, do something
Else
' it's not, do something else
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access