Run Time error 3061 1

[IamCornholio]

I'm getting the evil error 3061. I typically find that I get this when I run SQL in code. My code is as follows...

[blue]
strSQL = "Select a.Supervisor "
strSQL = strSQL & "From tbl_PersonnelInformation a "
strSQL = strSQL & "Where Last_Name = " & Me.cboLastName & " "
strSQL = strSQL & "AND First_Name = " & Me.cboFirstName ' & "'"

Set db = CurrentDb()

Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)
[/blue]

It keeps telling me its expecting two parameters. Would this be because I'm passing two combo box values to the query?

Any help is appreciated.
Thanks
Corn.

 

[genomon]

strSQL = strSQL & "Where Last_Name = " & Me.cboLastName & " "
strSQL = strSQL & "AND First_Name = " & Me.cboFirstName ' & "'"


Try enclosing Me.cboLastName in single quotes;
Get rid of the single quote in Me.cboFirstName '
Like this:

strSQL = strSQL & "Where Last_Name = '" & Me.cboLastName & "' "
strSQL = strSQL & "AND First_Name = '" & Me.cboFirstName & "'"

Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.

 

[IamCornholio]

[blue]WOW......!!!!!! I mean WOW, thats wierd, but simple... wonder why its like that?[/blue]

Heres a star for ya CLICK!!!

 

[genomon]

SQL ikes its strings enclosed in single quotes. Go figure...
Glad it worked & thanks for the star!
A virtual cold beer back at ya!



Outside of a dog, a book is man's best friend. Inside of a dog it's too dark to read.