Passing query parameters thru form

V

vikram_singh

I have one Pivot Chart Form (FrmChart) and form is taking data from
one query. but the query generates resultsets after having the
parameters value. I have another form (CallingFrm) which is calling
to FrmChart form.
so before i get the data in pivot chart form i should have query
executed with parameters. so i am using code below:

Set qryDef = CurrentDb.QueryDefs("MyQuery")
qryDef.Parameters("Qtr") = ChartQtrCmb.Value
qryDef.Parameters("yr") = ChartYearCmb.Value

'qryDef.OpenRecordset (dbOpenForwardOnly)
'qryDef.Execute
'I tried both but doesnt work.

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "metrixDataTbl", acFormPivotChart

But it got message again to put the parameters again. so is there any
way round to solve this. I wrote query bcoz i want to format pivot
table according to Client's choice.

Please do let me if there is possibility.

Thanks in advance.
Vikram Singh
 
Top