Forms :: COUNT Inquiry - 3 Drop Down Button That Filter Category Of Items In A Database

There are 3 drop down button that should filter category of items in a database:

Category 1
Category 2
Category 3

Whatever users choose in category 1, it will filter the items in Category 2. whatever users choose in category 2, it will filter the items in category 3. users can choose 1 to 2 categories or sometimes the 3 categories. the items will show in a subform. the subform are getting the items from a query. the dropdown button gets its value from a Table.

My challenge is that, i want to get the number of items in Category 1 once users chose it. if they choose something in Category 2 the number of items will change also. there will be 3 textbox for Category 1 COUNT, Category 2 COUNT, and Category 3 COUNT.

as of now, what im getting is only the filtering of Category 1 and Category 1 COUNT.