My Subform will not recognise past transactions (1 Viewer)

atrium

Registered User.
Local time
Tomorrow, 03:30
Joined
May 13, 2014
Messages
348
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
 

Ranman256

Well-known member
Local time
Today, 13:30
Joined
Apr 9, 2015
Messages
4,337
turn off the filters
Filter On Empty Master -NO
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:30
Joined
May 7, 2009
Messages
19,237
set Data Entry to No.
you will not "see" previous records when this is set to Yes (meaning only New record is accepted).
 

atrium

Registered User.
Local time
Tomorrow, 03:30
Joined
May 13, 2014
Messages
348
arnelgp you were spot on - thank and everyone else who helped (y)
 

Users who are viewing this thread

Top Bottom