I have two forms frmSalvage with a record source of tblCAP and frmBag1 with a record source of tblBagSpec.
frmSalvage has a subform frmDefectInfo with a record source of tblDefectInfo
frmBag1 has a subform frmburstData with a record source of tblBursts
tblDefectInfo (many)is related to tblCAp (one) and tblBursts (many) is related to tblBagSpec (one) and is also related to tblDefectInfo (one).
When I open frmSalvage I have subform frmDefectInfo embedded in it. frmDefectInfo has a command button to open frmBag1 with subform frmburstData embedded in it.
What I would like to do is when I use the command button to open frmBag1 I would like to have the [tblDefect].[ID] field populate the [tblBursts].[DefectInfoID] field, so that I can sort the data by defect Id
Doc2.zip