Query Expression Error

[corbinap]

Ok - this is what I am trying now and I have tried with and with brackets - I am getting an error "Missing ),], or item in query expression
(tblusers.userID='dev)". And if I can't or should not use Execute - in the Set rst, what can I use????

Dim SQL As String

SQL = ("SELECT tblUsers.MgrID " & _
"FROM tblSourcingManagers " & _
"INNER JOIN tblUsers " & _
"ON tblsourcingmanagers.SourcingMgrID = tblUsers.SourcingMgrID " & _
"WHERE (tblUsers.UserID='" & CurrentUser & "'")


Set rst = CurrentProject.Connection.Execute(SQL)

 

[PHV]

WHERE (tblUsers.UserID='" & CurrentUser & "'[!])[/!]")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JerryKlmns]

thread705-1305736

 

[JerryKlmns]

Hit submit too soon..

Pls do read faq181-2886 as TheAceMan1 suggested on his welcome post. Double posting is on #4 along with multiple-forum posting