Run-Time error '2342':

[David Kennedy]

Can anybody tell me why I am getting the error below
when I run the sqlQryMfr statement?
I`ve checked the statement in the immediate window and it looks ok.

Run-Time error '2342':
A RunSQL action requires an argument consisting of an SQL statement



sqlQryMfr = "SELECT DISTINCT " & TableName & ".Manufacturer FROM " & TableName & ";"

DoCmd.RunSQL sqlQryMfr

Thanks in advance
David K

 

[Lynn Trapp]

DoCmd.RunSQL will only work with Action Queries (Insert, Update, Delete). You can use DoCmd.OpenQuery for Select Queries.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Can anybody tell me why I am getting the error below
when I run the sqlQryMfr statement?
I`ve checked the statement in the immediate window and it looks ok.

Run-Time error '2342':
A RunSQL action requires an argument consisting of an SQL statement



sqlQryMfr = "SELECT DISTINCT " & TableName & ".Manufacturer FROM " & TableName & ";"

DoCmd.RunSQL sqlQryMfr

Thanks in advance
David K