Select from combo box(RESOLVED)

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

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

VB Code:

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