PDA

View Full Version : open a parameter query



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

HiTechCoach
03-14-2011, 03:15 PM
What is the Where Clause for the Query?