Child subform not excepting data

[graeme34 via AccessMonster.com]

This is probably a oversight on my part but can anybody tell me why my
subform, goods received details is not accepting input. The control source of
the subform is based on a select query, There are six controls on the subform,
yet only one is required for data entry, I have locked the other five as
these are for information purposes only. the control for data entry,
(quantity received) is not locked and enabled. The subform data entry
property is set to true. yet it is not letting me enter data.
Here is the control source query if this helps...
SELECT qrySumQuantityReceived.PurchaseOrderNumber, qrySumQuantityReceived.
ProductCode, qrySumQuantityReceived.Description, qrySumQuantityReceived.
[Quantity Order], qrySumQuantityReceived.Price, qrySumQuantityReceived.
SumOfQuantityReceived, [Quantity Order]-[SumOfQuantityReceived] AS
Outstanding, tblGoodsReceivedDetail.QuantityReceived

FROM qrySumQuantityReceived INNER JOIN tblGoodsReceivedDetail ON
qrySumQuantityReceived.ProductCode=tblGoodsReceivedDetail.ProductCode

ORDER BY qrySumQuantityReceived.PurchaseOrderNumber;

Any ideas where I'm going wrong ??

 

[graeme34 via AccessMonster.com]

Hi Rick

Your right the underlying query is not updatable....I think it is because Iam
using group by

What I am trying to do is create a goods received entry form, with the sub
form having the controls: Purchase order number (hidden, but used for the
link to master)(tblPurchaseLine), product code(tblPurchaseLine), ordered
(tblPurchaseLine), description(tblProduct), Price(tblPurchaseLine),
Outstanding( I want this control to be ccalculated based on (Ordered - (any
other previous recieved quantities, i.e. SumQuantityReceived as there can be
more than one occurance of goods being received) and Received
(tblGoodsReceived).

The received control is the only control is wish to update.

Is this a bit clearer why I need to use the SumQuantityReceived??

Any suggestions??

This is probably a oversight on my part but can anybody tell me why my
subform, goods received details is not accepting input. The control

[quoted text clipped - 18 lines]

Any ideas where I'm going wrong ??

Queries with more than one table are often not editable. Open that query
directly in datasheet view and see if you can make edits. There is a help topic
"When can I update data in a query" that you should check out.

Multi-table queries are somewhat unusual in a bound subform. Any reason why you
need the qrySumQuantityReceived in there? The MasterLink and ChildLink
properties of the subform object should be sufficient to provide the linked
behavior.