Curios.....relating to groups

[komo]

Hi Everyone,


Is it possible to create groups in a listbox so that when a user select the group(s) and clicks on a button to enter a value it will generate the value to all of the items in those group(s)?


What's the best approach in order to accomplish this?

Lets say it's relating to orders for food:

Chips.............. Cookies.............. IceCream
Jalapeno............ Mint................... Chocolate
Cheddar......... Chocolate Chips......... Vanilla
Oatmea..........................................l Suprise

So if I select "Chips and Cookies" and enter the text value (10) it will autopopulate a list with all items relating to those two groups in a table (tblOrder) with the value 10 on each one?

 

[Ranman256]

in a query, add all tables,
tChips
tCookies
tIceCream

DO NOT JOIN THE TABLES
bring down the name from each table into the query
run...all combinations will be created.

 

[Galaxiom]

I don't think Ranman's suggestion is what komo wants.

What I think they want can be done using VBA but I would like to know how the data is currently held and exactly the output required before I tried writing the code.

 

[komo]

I don't think Ranman's suggestion is what komo wants.

What I think they want can be done using VBA but I would like to know how the data is currently held and exactly the output required before I tried writing the code.

Yes Ranman's way wasn't working. I have another condition for the lisbox where not only are there FoodProducts (Cookies, IceCream,Chips, etc.) there is FoodTypes (Sweet and Savory) within the groups for selection.

I originally had one table (tblFood) and it has the following fields
ID
FoodName
FoodProduct (which is number that links to another table with the FoodProduct ID for lookup ----Cookies, IceCream, Chips,)
FoodType (which is number that links to another table with FoodTypeID---Sweet, Savory)



I was able to utilize the cascade combo box option for the FoodProduct to filter the listbox.....but since I am adding another group (FoodType) I am not sure how to do that.......

again, I would like both FoodType and FoodProduct to be in one combo box for selection.... OR a way to create two combo boxes to filter the SAME ListBox......