COUNT Inquiry

[gatsby]

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.

[essaytee]

You need to place code in the AfterUpdate event of your combo boxes. The code placed there requeries the other combo boxes ( eg. combo1.requery).

Steve.

[gatsby]

yup ive tried that one. all of the combo boxes have Requeries. but only the first combo box is working.

[essaytee]

yup ive tried that one. all of the combo boxes have Requeries. but only the first combo box is working.

Seems as though the queries in your second and third combo boxes are not configured correctly. The second combo box query (SQL) should have a field name equal to the first combo box control, if it hasn't then it will never work. Likewise, the third combo box query should have a field name equal to the second combo box control.

Steve.

[gatsby]

Seems as though the queries in your second and third combo boxes are not configured correctly. The second combo box query (SQL) should have a field name equal to the first combo box control, if it hasn't then it will never work. Likewise, the third combo box query should have a field name equal to the second combo box control.

Steve.

i tried it also in my testing but its not working also. attached us the original database

[OTOTO]

I unzipped the file and its telling me that it's an Unrecognized database format. Not sure why...