Disappearing Data

[stfcTerryA]

I have a frmGoodsIn with a subform frmGoodsInItems on the subform i have a
combo box which is filtered by the user selection in a parent combo box via
an AfterUpdate event on that combo.

When i close the form and reopen it the first record say 1 of 6 is the only
form/subform where the subform combo box has data in, the rest 2 of 6 etc are
blank until i reselect the parent combo and the data reappears.

The table still has the data in it (well the bound column data ID)

Any ideas of how to resolve this?


Cheers



Terry A

 

[ntc]

a subform that doesn't show data when data is definitely in the subtable can
only mean the subform can't find the parent form cross reference; why that
is - in your case I can't tell from your explanation...but surely that is the
issue and the fact that resetting the parent combo makes that cross reference
work is a confirming hint in this direction....not much help but.....

 

[stfcTerryA]

SELECT tblPurchaseOrderItems.POrderItemsID,
tblPurchaseOrderItems.POrderID,
tblComponents.PartType,
tblPurchaseOrderItems.Quantity,
tblPurchaseOrderItems.QtyOutstanding

FROM tblComponents

INNER JOIN tblPurchaseOrderItems ON tblComponents.ComponentID =
tblPurchaseOrderItems.Component

WHERE (((tblPurchaseOrderItems.POrderID)=Parent![PurchaseOrder]))

ORDER BY tblPurchaseOrderItems.POrderItemsID;

Now on the parent combo box i've and AfterUpdate()

Me.frmGoodsInItems.Form.POrderItemsID.Requery

What i've now noticed is actually i don't even need to close the form and
reopen it to see missing data i only need to go back a record and the data is
missing.


Various Options for Parent![PurchaseOrder] i've tried

1) [Forms]![frmGoodsIn]![PurchaseOrder]
2) [Me].[Parent]![PurchaseOrder]
3) [Me]![txtPONumber] (I've tried using a unbound text box on the subform to
get the PO number of the parent form - whats annoying is the text box does
show the value of parent form but it still doesn't work)