ApplyFilter

  • Thread starter Thread starter JGR
  • Start date Start date
J

JGR

I am not understanding the ApplyFilter command.

I am trying apply a filter on ComboBox2 (intBBP_No_ID)
based on the based on the selection made in ComboBox1
(intEventID)

ComboBox1 selects the event: Shipped or Returned

ComboBox2 then needs to be filtered as follows:
tblJobOrders
intMasterOrderID (1 to Many)
int&txtOthers

tblBBP_LineHist
intBBP_LineHistID (1 to Many)
intMasterOrderID
intEventID (Shipped or Returned)
int&txtOthers

tblBBP_HistTrac
intBBP_HistTracID
intBBP_LineHistID
intBBP_No_ID

tblBBP_No
intBBP_No_ID (1 to Many)
ysnAvaliable (Yes or No)
int&txtOthers

The goal is to filter BBP_No_ID for ComboBox2

If EventID= Shipped then
All BBP_No_ID where ysnAvaliable=Yes
ElseIf EventID= Returned then

Filter tblBBP_LineHist where
tblBBP_LineHist(intMasterOrderID)= tblJobOrders
(intMasterOrderID)

Filter tblBBP_HistTrac where
tblBBP_HistTrac(intBBP_LineHistID)= tblBBP_LineHist
(intBBP_LineHistID)

Filter tblBBP_No where
tblBBP_No(intBBP_No_ID)= tblBBP_HistTrac(intBBP_No_ID)
and (ysnAvaliable=No)

When BBP_No_ID is selected, ysnAvaliable for this record
is changed to “Yes”

Any help would be appreciated.
Thanks
 
Back
Top