sorry if i didn't explain well enough,
i have various tables but the one that supports my Subform has
product code, size, supplier, allocated Stock, amount in stock and Price
i am trying to Total a Textbox were the source is the Product code combo box.
so my combo box choose's it product...