Data filtering by form/subform using same record set

good day !



I have a form and subform where i have table data in the subform and 03 Combo box in the main form header. I need to do some filtering using combox box1 and out of that filtered records i need to do one more filtering using combobox2. then again another filtering by Combobox3. ( same way we are doing in Excel)



Subform is running on a query where i have following fields;

Vessel

Voyage,

POL

POD

MLO



by Combo box 1 i need to filter Voyage

by Combo box 2 i need to filter POL ( out of the data filtered by above )

by combo box 3 i need to filter POD ( out of the data filtered by both above )



Kindly seek your assistance to write a suitable VBA codes. thanks in advance !

Data filtering by form/subform using same record set