Adding Totals to Combo Box

[adamjon92]

Hello,

I currently have a combo box where when you choose a company name, all of the totals come up for that company in a subform, including spend, tonnage, and spend per ton on each lane that ABC ships on. Whenever I click ABC, for example, all of the data comes up for only ABC and the lanes it ships on (let's call them Lanes 123, 456, and 789). I have roughly 50 different companies on the list, and I was wondering if there was any way to have an option for totals in the company name drop box, so when I click totals, all of the different lanes and companies come up in the subform. So for lane 123, companies ABC, DEF, and GHI would come up so I could compare the spend, tonnage, and spend/ton with each of them.

Thanks,

Adam

[ranman256]

yes, instead of the query you use to fill the box of companys, use a sum query on each company so you get 2 columns: CO , SUM
Set the combo to show 2 columns. (also set the Col.widths too, else it will be random)

[adamjon92]

Sorry, I wasn't clear enough in my question. Basically, whenever I select a company from the combo box, it shows all of the data for that company in the subform. The combo box works as a filter for the company name column in the subform. In the table that the subform is the being pulled from, there are 50,000 rows, so there's roughly 1,000 rows of lanes for each company (because I have 50 companies in my combo box). So whenever I select a company, there are 1,000 rows that show up for that company. Instead of only selecting one company at a time (and basically filtering the results for one company), I want to include all 50,000 rows in the subform. So in simple terms, I want to remove all filters and have every single row, regardless of the company, in the subform. Does that clarify at all? Thanks.

[ssanfu]

Where is the combo box? In the main form header? Sub form header?


Is there code in an event of the combo box?


What happens if you open the subform in stand alone mode? Do you get the results you want?

[adamjon92]

Where is the combo box? In the main form header? Sub form header?


Is there code in an event of the combo box?


What happens if you open the subform in stand alone mode? Do you get the results you want?

Thanks for the reply. The combo box is currently in the main form detail section. There is no code for the combo box. The row source is just the table that the information is being pulled from. In terms of the stand alone mode, that is exactly what I am looking for. It is all of the data that I need, and it isn't broken up by the company name. I want to be able to include that all in the sub form, but when I select a company name from the combo box, it filters the company name column in the sub form, and only shows those results. Hopefully I'm making sense. Thanks!

[ssanfu]

I am having a hard time visualizing how your dB is set up. Any chance of posting your dB? Just need 3 or 4 records for a couple of companies. Change any sensitive info.
Do a Compact and Repair then zip it.