I used four command buttons, for the four menu item categories.
so, when I click the drink button, the subform should be able to display all the drinks only, when I l click the Main Course button, all and only the items in the Main Course category should be displayed............
that's what i was trying to achieve.
how to filter a subform without affecting the main form?
under the four command buttons, i created four AppllyFilter Macros(one for each), including Drink Filter, Main Course Filter, Dessert Filter and Appetizer Filter.
but whenever I click any of the command buttons, the filter will filter the main form also.
it would be great for me if the filter only filter the subform and has no effect on other data on the main form.