philfer
03-11-2011, 05:45 AM
Hello,
I am trying to open a parameter query. I do :-
Set Qdf = CurrentDb.QueryDefs(QueryName)
Qdf.Parameters("CustID") = CustID
Qdf.Parameters("Ctrl1") = CtrlGrp1
Qdf.Parameters("Ctrl2") = CtrlGrp2
Qdf.Parameters("CCY Name") = CCYName
Qdf.Parameters("Start") = FromDate
Qdf.Parameters("End") = ToDate
Qdf.Parameters("Ctrl3") = CtrlGrp3
Qdf.Parameters("Ctrl4") = CtrlGrp4
DoCmd.OpenQuery QueryName, acViewNormal
But it gives me the parameter entry boxes in order to get user entry for the parameters even though I have already set them
Confused as to why this is
Thank
P
I am trying to open a parameter query. I do :-
Set Qdf = CurrentDb.QueryDefs(QueryName)
Qdf.Parameters("CustID") = CustID
Qdf.Parameters("Ctrl1") = CtrlGrp1
Qdf.Parameters("Ctrl2") = CtrlGrp2
Qdf.Parameters("CCY Name") = CCYName
Qdf.Parameters("Start") = FromDate
Qdf.Parameters("End") = ToDate
Qdf.Parameters("Ctrl3") = CtrlGrp3
Qdf.Parameters("Ctrl4") = CtrlGrp4
DoCmd.OpenQuery QueryName, acViewNormal
But it gives me the parameter entry boxes in order to get user entry for the parameters even though I have already set them
Confused as to why this is
Thank
P