I have a subform with an item. I also have a combo box named COSTPRICE to lookup the value of the item (bound to the itemID) from an unrelated table. The combo box does it's job and returns the value from the 8th column using 0",0",0",0",0",0",0",1" column widths.

The problem I have is there is also a text box named TOTALCOST to get a calculation of the total value of the item using =qty*COSTPRICE. Instead of multiplying the cost price, it returns the qty times the ItemID.

What do I need to do to correct this error?