Run-Time Error 3601 -- Too Many Parameters

[bostonfrog]

Before submitting this, I did read other posts regarding this run-time error but didn't find the answer.
It's a simple DAO Recordset (Dim Rs as DAO.Recordset), and I get this error, saying there TOO MANY PARAMETERS, Expected 1 -- and no help available on the subject.

strSQL = "SELECT PATIENT.ID FROM tblPATIENTS "
strSQL = strSQL & "WHERE PATIENT.ID = Forms!MyForm!txtID;"
Set rs = Currentdb.OpenRecordset(strSQL)

On this error, the Set rs = line of code is highlighted in yellow and rs = nothing is the tip when I click on the error. Any advice, DAO experts?

 

[xjs]

at a quick glance you need to adjust your query string and quote marks.

strSQL = "SELECT PATIENT.ID FROM tblPATIENTS "
strSQL = strSQL & "WHERE PATIENT.ID = " & Forms!MyForm!txtID & ";"
Set rs = Currentdb.OpenRecordset(strSQL)

 

[TonyJollans]

Hi bostonfrog,

I suspect it's because you are trying to find PATIENT.ID in Table tblPATIENTs.

Enjoy,
Tony