Subform

[Revned]

i have a subform name [OrderSubform] under my main form with a Record
Source: qryOrder
with the following SQL from a query object

SELECT OderTable.OrderRef, OderTable.CustomerID, OderTable.[Item Code],
Item.Description, OderTable.Quantity, Item.Price, [Quantity]*[Price] AS
Amount, OderTable.[Date Order], OderTable.[Date required], OderTable.[Date
Deliver], OderTable.Remarks
FROM OderTable INNER JOIN Item ON OderTable.[Item Code] = Item.[Item Code];

when i enter the Item code in Item code column of my subform under my main
form it populate the item description in Description column and price to
Price column then I manually enters the qty in Qty column and the Amount
column calculates [Qauntity]* [Price] so it works will so far

but the problem is when I check and open the tblOrder where my query is
bound only the Item Code and the Price are populate in table but the
Description and the Amount are empty

i am using access 2003, pls. i just want to know what could be the best way
to handle this?

pls.if there is a need to reconstruct my SQL i will appreciate it.

thanks in advance