Passing more than one parameter to a pass thru query -HELP

[richmond88]

Hi All,

I have an unbound mdb and I pull data down to a local table from an SQL 2000 Server - Set out below is how I do it.

At the moment the I only pass one parameter which is & Forms!frmCurrentUserDetails!txtCalendarYrID & "'", _


I now want to pass the pass thru query 2 parameters but i have struggled all day with it - any ideas would be gratefully received.

'Delete Current Data in Local Table tblStudentData
db.Execute "DELETE * FROM tblStudentData"

Call PassThroughFixup( _
"qselsptKS3StudentData", _
"EXEC procKS3StudentDataSelect '" & Forms!frmCurrentUserDetails!txtCalendarYrID & "'", _
Forms!frmlogin.ODBCConnect)
CurrentDb.Execute "qappKS3StudentDatatotblStudentData