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.
use sql statemetn to query subform.
Posted - 11/16/2006 : 18:06:45
