1 form works and a similar form does not.

[spidge32]

I have 1 form Job Sheet which works well. I have another form which uses a different start table via a lookup but uses the same sub forms . The unbound field to select which part is being updated in the sub forms. The only change is the lookup for the master form and the Header form which is a copy of the original header form in the original job sheet.

[June7]

Which is the 'another form'? What does 'not work' mean - error message, wrong result, nothing happens?

[spidge32]

The first form frmJobSheet which works has 3 sub forms, frmJobSheetTrfHdr, frmJobSheetWdgDetail and frmTerminationData. The underlying data is linked by the unbound field in the frmJobSheet using the query qrylookupjobsheet which the source is tblpart. I needed to make another form which is similar except for the subform frmJobSheetTrfHdr, this form is frmJobSheetTrfHdr3. So I copied the frmJobsheet to frmJobsheet3 and changed the query as its source to qrylookupjobsheet3 which uses the table tblpart3.
The unbound field is Jobsheetcombo. In the first frmjobsheet the selection of the part No is used to update the 3 sub forms, but in the frmJobsheet2 the underlying subforms are not updated.

The form frmJobSheetTrfHdr3 is not in the relationships, can I add it and have 2 tables at the start of the relationships?

[spidge32]

Ignore my last line... I don't know what I was thinking, getting confused with tables and forms.