Apply an existing query as a filter on a form

D

Danish

Hi All,
I am converting a version 2.0 to Access 2000, in one of the forms i have a
filter by query criteria and i have pasted the query:
"SELECT [qryaccountsdetail].[sl4], [qryaccountsdetail].[account],
[qryaccountsdetail].[short_na], [qryaccountsdetail].[country],
[qryaccountsdetail].[risk_grade]
FROM qryaccountsdetail
INNER JOIN
qrysl4pwaccounts
ON [qryaccountsdetail].[account]=[qrysl4pwaccounts].[account]
WHERE
[qrysl4pwaccounts].[sales_level]=[forms]![frmSL4_PWA_ACCOUNT]![sales_level]
And [qrysl4pwaccounts].[product]=[forms]![frmSL4_PWA_ACCOUNT]![product] And
[qrysl4pwaccounts].[iso_currency_code]=[forms]![frmSL4_PWA_ACCOUNT]![iso_currency_code];
"
The problem here is in 2.0 this filter is working fine with curent form
taking parameters directly from the form (frmSL4_PWA_ACCOUNT) without any pop
up. But in 2000 it asks for entering the parameters for all 3 criteria rather
than picking them from previous form automatically.
Rest i have checked eveything is similar in 2.0 and 2000..
Can anyone one suggests how to avoid this pop up for parameters in 2000??

Thanks in advance..
 
Top