I have the parent and child relationship on the right fields for both files.
I can add a record into the subform - no problem. I check the source file to the subform and the new record is there and correct.
I can run the query datasheet view for the subform and manually enter the criteria and I get the right records, including the one just created.
So it points to the criteria field - that it's not carrying the right OrderNo value. The criteria is pointing to [Forms]![OrdersFrm]![OrderNoFld]
a field set up that has the OrderNo (name = OrderNoFld) of the Orders file bound to it on the parent form. I have set it to visible for the moment so I can see what's happening. It's showing the right value.
Record Source - ItemsOrderedOnlyQry
Record Set Type - Dynaset (Inconsistent Updates)
Fetch Defaults - Yes
Filter -
Filter on Load - Yes
Order By -
Order By On load - Yes
Wait for Post Processing - Yes
Date Entry - Yes
Allow Additions - Yes
Allow Deletions - No
Allow Edits - Yes
Allow Filters - Yes
Record Locks - No Locks
The format view has Default View - Continuous Forms
OrdersSubform
Data
SourceObject - OrdersSubform
Link Master Fields - OrderNo
Link Child Fields - OrderNo
Filter On Empty Master - Yes
Enabled - Yes
Locked - No
I can add a record into the subform - no problem. I check the source file to the subform and the new record is there and correct.
I can run the query datasheet view for the subform and manually enter the criteria and I get the right records, including the one just created.
So it points to the criteria field - that it's not carrying the right OrderNo value. The criteria is pointing to [Forms]![OrdersFrm]![OrderNoFld]
a field set up that has the OrderNo (name = OrderNoFld) of the Orders file bound to it on the parent form. I have set it to visible for the moment so I can see what's happening. It's showing the right value.
Record Source - ItemsOrderedOnlyQry
Record Set Type - Dynaset (Inconsistent Updates)
Fetch Defaults - Yes
Filter -
Filter on Load - Yes
Order By -
Order By On load - Yes
Wait for Post Processing - Yes
Date Entry - Yes
Allow Additions - Yes
Allow Deletions - No
Allow Edits - Yes
Allow Filters - Yes
Record Locks - No Locks
The format view has Default View - Continuous Forms
OrdersSubform
Data
SourceObject - OrdersSubform
Link Master Fields - OrderNo
Link Child Fields - OrderNo
Filter On Empty Master - Yes
Enabled - Yes
Locked - No