new wizard form from qry give popup without using parameter

[ano]

SELECT a.dt, sum(a.bal) AS bal, (SELECT sum(b.bal) AS [bal1]
FROM bal b
where datediff("d",b.dt,a.dt) between 10 and 50 and dm=0
GROUP BY b.dt
order by b.dt) AS bal2
FROM bal AS a
WHERE dm=0
GROUP BY a.dt
ORDER BY a.dt DESC;


SELECT a.dt, a.bal, ( a.bal - a.bal2) AS sav
FROM [bal Query] AS a
ORDER BY a.dt DESC;

this works as needed
but form data has filter filled with bnk=8 not on load and order with dt desc wich give popup
both lines removed solve the problem

[madpiet]

Since [bnk] isn't in the underlying recordset that the form is based on, how is the data engine supposed to figure out where the value of [bnk] comes from?
Change the query so that it includes that column (whether you show it or not in your form/report) and it should work fine.

[ano]

bnk is part of table but not needed for the query. and certainly not needed as filter because the banks are summarized.
why order by is generated is also not clear becuse the qry works perfect jus want sum and cross combined because cross cannot calculate the diff between 2 line