Subform populating table with everything but the linked field to main form

[smg]

I have a form and subform on the attached, called frmAssessment and frmBehaviorsSubform. Assessment Detail is the table in question. It's data comes from the subform form. It feeds all the data to the Assessment Detail table except for the Assessment No. See Assessment Detail table IDs 190-192, they are blank but should have Assessment No 17. Because of this, when you go back to the form to view records, record 17 only shows the main form info and not the info that was entered when the form was filled out. This was working when the form was created and through the first 16 records input. Not sure what I did that broke it. Main form info is in Assessment Table and Summary table. Db attached.

[Missinglinq]

Assessment No is not included in the Query your Subform is based on...hence it can't be passed on to the underlying Table.

Presumably the data in the Table that includes Assessment No was entered in some way other than using the Subform...or the Subform's Query has been changed.

Linq ;0)>

[smg]

added the following code to the subform and it works correctly now.
If Me.NewRecord Then
Me.Assessment_No = Me.Parent.[Assessment No]
End If