How to add Text type input vaule into SQL

[max_1999]

Hi

The rmCode.Value should be a text vaule, but in the Set rs = cnn.Execute(SQL), the SQL become "select * from target where branch=TEXT". I need the SQL become to "select * from target where branch="TEXT"", otherwish it could not exe by SQL.

Please refer to below code for details.

Thank you!

-----------------------------------------------------------------------
SQL = "select * from target where branch= " & rmCode.Value & ""
Set rs = cnn.Execute(SQL)

[mudraker]

Please take a couple of minutes and read the Forum Rules then wrap your VBA code (Rule 3)

[T-J]

Either use single quotes around the text value or double-up the double quotes, but easier to use the single quotes.

Please Login or Register  to view this content.