docmd.runsql

ethicalcage · March 29th, 2012, 05:04 PM

HI I am rather new to access VBA.

i would like to use a variable in a sql statement ie

dim val1 as string
dim strsq1 as string

val1 = "test"

strsql = "select * from table1 where col1 = val1 into test1"

docmd.runsq strsql

but am having issues with the syntax

any help is appreciated

thanks

JP · March 30th, 2012, 12:58 PM

To get the value of a variable into your SQL statement you would write it like this:

Code:

 
strsql = "select * from table1 where col1 = '" & val1 & "' into test1"

Also I believe it is "docmd.runsql" not "docmd.runsq"