I am trying to create a string variable that I will use as a SQL argument. See example below.

user_input=TextBox.Value
strsql = "SELECT abc FROM def WHERE abc=" & user_input

The user input needs to be enclosed in apostrophes for the SQL statement to work, as abc is a Text value. So, the result I want is that strsql = SELECT abc FROM def WHERE abc="USER SELECTION"

How can I get apostrophes around the USER SELECTION, using a concatenation as shown above?

Thanks for any help that I can get on this!

Matt

Matt

You should be able to use single quotes:

strsql = "SELECT abc FROM def WHERE abc='" & user_input & "'"

If not, you have to tell Access that you really, really want to put a double quote in there:

strsql = "SELECT abc FROM def WHERE abc=""" & user_input & """"


Brian Skelton
Braxis Computer Services Ltd.

strsql = SELECT abc FROM def WHERE abc='" & USER_INPUT & "';"


Kenny Alligood