S
Stapes
Hi
I have set up my update query called "qryUpdSalesMandate"
I then refer to it in my code: -
Set qd = db.QueryDefs("qryUpdSalesMandate")
I set all my parameters: -
' this one is the record selector
qd.Parameters("pCO").Value =
Forms!FRM_Frontoffice4_T7_Selling!T7_Contracting_Company
' these are fields to be updated
qd.Parameters("pSPOT").Value = mySpotMandate
qd.Parameters("pFWD").Value = myForwardMandate
qd.Parameters("pREMAIN").Value = myRemainingMandate
But how do I run it? I tried this: -
Set rs = qd.OpenRecordset
but I get 3219: Invalid operation.
Ever get one of those days
Stapes
I have set up my update query called "qryUpdSalesMandate"
I then refer to it in my code: -
Set qd = db.QueryDefs("qryUpdSalesMandate")
I set all my parameters: -
' this one is the record selector
qd.Parameters("pCO").Value =
Forms!FRM_Frontoffice4_T7_Selling!T7_Contracting_Company
' these are fields to be updated
qd.Parameters("pSPOT").Value = mySpotMandate
qd.Parameters("pFWD").Value = myForwardMandate
qd.Parameters("pREMAIN").Value = myRemainingMandate
But how do I run it? I tried this: -
Set rs = qd.OpenRecordset
but I get 3219: Invalid operation.
Ever get one of those days
Stapes