Best way to do this...

[Greyowlsl]

Hi,

Ill be a using a cheese store chain as an example.

First...
I have a form (Cheese stock) with a combobox (Stores) and a bunch of text boxes (Types of cheese). When a store is selected, each type of cheese shows its stock for that store... I understand there is better/other ways to display this data then in text boxes, but this cannot be changed, so you'll just have to work with it. The form's source is a table that has a column for every type of cheese, and a row for each store... This also cant be changed... sorry.
This all works fine for the moment.

Next...
I have a query (cheese sold), which has two columns, productID group by (type of cheese) and productID count (amount of cheese sold).

Now...
What i need is that when i select a store in the cheese stock form, that the stock for each type of cheese gets multiplied by the corresponding cheese type in the cheese sold query. The results of this are added together and then shown in another text box on the cheese stock form.

Thanks for your time,

Kind regards,
Leon