I'm using Ms Access 2016. I Have a query as QueryStock like this :
SELECT T_Stock2.Code_Stock, T_Stock2.Stock FROM T_Stock2 WHERE (((T_Stock2.Stock)=IIf([Forms]![F_Stock]![checkbox1]=False,[Stock],[T_Stock2]![Stock]<>0)));
I have a form with checkbox. I want to requery QueryStock after update the checkbox (true or false)
But I have problem with the [T_Stock2]![Stock]<>0. Its not show like I want.
Any idea for the query statement ? Thank you
Aucun commentaire:
Enregistrer un commentaire