COUNT Inquiry

[davies107]

anyone knows what should i do or codes should i put? my problem is that, 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.

 

[Uncle Gizmo]

I think this is what you are after:-

Combo Boxes Filter, by All or Some

Theres a YouTube, Text and Picture explanation and a Download sample DB...

 

[davies107]

I think this is what you are after:-

Combo Boxes Filter, by All or Some

Theres a YouTube, Text and Picture explanation and a Download sample DB...

thanks. but do i need to register to see the tutorials?

 

[Uncle Gizmo]

thanks. but do i need to register to see the tutorials?

Yes... Otherwise the site gets filled up with Spam.

 

[Uncle Gizmo]

Ah, Alternatively I could send you the sample in an email if you like.

And here is the YouTube:-

Combo Boxes Filter, by All or Some

 

[davies107]

i want to attach my database but it says:

Your submission could not be processed because a security token was missing.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.



i dont know why.....
​

 

[vbaInet]

Try zipping the file and uploading the zip.

 

[davies107]

okay thanks....

database is attached already.

so my challenge here is the filtering of combo boxes at the right side and the COUNT....

@Uncle Gizmo: i watched your video and it was informative but i cant apply it in my database. im not an expert with access.