Sql Statee=ment

[dbowling]

What is wrong with with this statement?
I am trying to return the valve that is listed in a combobox.

dim sSql as string
sSql = "Select * From CustomerTable Where Name = " & Combobox & "
Thanks for your help

[marex]

I see unpaired quotes.

Try this:

sSql = "Select * From CustomerTable Where Name = ' " & Combobox & " ' "

greetings