Select from combo box(RESOLVED)

[david maddison]

The combo1.text box contains table names but some times there is a space in the name and the select query will not work i have tried with and without brackets any ideas thanx


VB Code
________________________________________________
rs.Open " SELECT * " & _
" FROM " & (Combo1.Text), _
cnn, _
adOpenKeyset, _
adLockReadOnly, _
adCmdText
rs.MoveFirst
____________________________________________________End Code

[PilgrimPete]

Depends on your database, but try square brackets, or single quotes:

rs.Open " SELECT * " & _ 
" FROM [b][[/b]" & Combo1.Text & [b]"]"[/b], _ 
cnn, _ 
adOpenKeyset, _ 
adLockReadOnly, _ 
adCmdText 
rs.MoveFirst