Hi everybody ! I'm a new one in ADO and SQL Statement...

Two questions for you:

1) Is it normal that my statement got many (") ??? if answer it's no, is there a simple way to write this ???

strSQL = "SELECT * FROM " & adoTable & " WHERE " & adoField & " = " & "'" & adoCombo.Text & "'"

2) Finally, sometime I got an error because the value of adoCombo.Text = Column 6" x 8'

Error: Syntax error (missing operator) in query expression...

I thought it's because the (') after 8 and I tried to put 96" and I a got the same error ???

Thanks in advance for your help !