Child subform not excepting data

  • Thread starter Thread starter Rick Brandt
  • Start date Start date
R

Rick Brandt

graeme34 said:
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 ??
Click to expand...

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.
 
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 ??
 
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??

Rick said:
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
Click to expand...
[quoted text clipped - 18 lines]
Any ideas where I'm going wrong ??
Click to expand...

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.
Click to expand...
 
Back
Top