Unanswered: Runtime Error 3601 Too few parameters. Expected 1
I'm using MS Access 2000 and i'm trying to run some code and a i get a runtime "Error 3601 Too few parameters. Expected 1" message box pop up. What does this error message mean? I have submitted my code could you have a look to see where i'm going wrong.
Dim db As Database
Dim rsTable As Recordset
Dim iMem As Integer
Dim iName As String
Dim ivalue As Integer
Dim iCount As Integer
Dim sResults As String
Set db = CurrentDb
Set rsTable = db.OpenRecordset("tblMember", dbOpenDynaset)
sResults = "SELECT tblMember.MemberID, tblMember.FirstName, tblMember.Surname, tblMember.JoinFeePaid FROM tblMember WHERE (((tblMember.MemberID)=[Forms]![frmLoanDetails]![cboMem]) AND ((tblMember.JoinFeePaid)=0));"
Set rsTable = db.OpenRecordset(sResults, dbOpenDynaset) 'Line the error debug message appears'
iMem = rsTable!MemberID
If rsTable.RecordCount > 0 Then
ivalue = MsgBox("Member" & iMem & vbCrLf & "have not paid there joing fee", vbOKOnly)