Too few parameters. Expected 1

[spinkung]

Hi All,

I trying to get a sql query into a recordset but keep getting an error thrown back. The error is : Too few parameters. Expected 1.

Can anyone help with this?? Thanks.

sql = "SELECT * FROM Failures WHERE rs![user ID] = Failures.[Sales Contact]"
Debug.Print sql

[COLOR="red"]Set rs2 = CurrentDb.OpenRecordset(sql)[/COLOR]

 

[Mathematician]

Try do like this:

sql = "SELECT * FROM Failures WHERE rs![user ID] = Failures.[Sales Contact]"
docmd.runsql sql

 

[Rabbie]

Try this

sql = "SELECT * FROM Failures WHERE rs![user ID] = Failures.[Sales Contact];"
Debug.Print sql

Set rs2 = CurrentDb.OpenRecordset(sql)

I had a similar probelem that vanished when I put the ; at the end