Access: Perform Calculation on combo box lookup field
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?
.
PC - Ubuntu 15.04 64bit Desktop
HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home
"So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"
RIP Ramesh ...