L
lilbit27
I would like to filter a subform by using a sql statement in vba.
I want to be able to say. afterupdate on a combo box. select "*"
where[excd]<>"ne" and [billstatus] = bu then select the items where
[excd]="Ne" and [billstatus]<>= bu.
What I want is all the "BU bill status that [excd] does not equal "ne"
and all the items were {excd] = ne but the bill status does not equal
bu.
I want to be able to say. afterupdate on a combo box. select "*"
where[excd]<>"ne" and [billstatus] = bu then select the items where
[excd]="Ne" and [billstatus]<>= bu.
What I want is all the "BU bill status that [excd] does not equal "ne"
and all the items were {excd] = ne but the bill status does not equal
bu.