SQL error

[CLSkcab]

Background: Front End MS Access 2010 with VBA; Backend SQL Server 2008; Still learning SQL

I have the following statement coded

gblsSQL = "Select Role FROM [dbo_UserProgram] Where Program='Security' IDUser=" & gblID & ";"

It is generating this error: Run-time error (missing operator) in query expression Program='Security' IDUser=1'. What is wrong?
Thanks in advanced.

[Seth Schrock]

You are missing the comma between your two criteria. You should have

gblsSQL = "Select Role FROM [dbo_UserProgram] Where Program='Security' AND IDUser=" & gblID & ";"

[zmbd]

Please place a "stop" either before or after the string.
execute to the stop.
Then <ctrl><g>
Then in the immediate window type

?gblsSQL

[enter]
(also appears to be missing comma)
Cut and paste back the resolved string.

[CLSkcab]

I did as you requested and put in (,). This time I get the following message: Run-time error 3075, Syntax error (comma) in query expression 'Program='Security', IDUser=1'

[zmbd]

Please do the troubleshooting step as outlined in my post.

[Seth Schrock]

Oh, duh. The WHERE clause needs the word And or Or for multiple criteria. See my fix in post #2. And please do post the information requested by zmbd.

[CLSkcab]

I have a SQL table record:

ID int primary key
IDUser int secondary key points to the parent
Program varchar(50)
Role varchar(5)
.
.
.

I know the secondary key and program values. Hoe can I get the Role value? Any help will be appreciated. I did find where you can't use a Select like this.

[zmbd]

CLSkcab,

What we need to see here is the code that you are using and the resolved string as requested.

You can indeed retrieve the information you are looking for using a select query as the recordset-object. You only need to provide a clear question and enough detail for us to proceed.
(^_^)

[Luuk]

see first reply of 'Seth Schrock' where he said this (i only quote the SQL):

Select Role 
FROM [dbo_UserProgram] 
Where Program='Security' 
  AND IDUser=" & gblID & ";"