Duplicate Records in a Subform

[Bentley]

Hello,



I have a work order form set up and I am using a subform as well to track the inspection of the work order. However, when I set up a new work order, I get duplicate records in the subform... Can anyone advise why this is happening? When I beta tested the form, it appeared to be working correctly... I do not have any macro's or VB code on the form.

Thanks in advance,

Ben

[June7]

Is form RecordSource a query? Provide the SQL statement.

What did you do to Beta test, actually enter records and that was working properly? What has changed?

[Bentley]

I beta tested by adding records in the main form and subform. Now, when we use the DB, duplicate records show in the sub form and in corresponding tables. below is the SQL for the subform QRY used in the main form.

SELECT TBL_QC_Review.Status_ID, TBL_QC_Review.WorkOrder, TBL_QC_Review.[Quality ReviewDTE], TBL_QC_Review.ApprovedDTE, TBL_QC_Review.Inspector, TBL_QC_Review.ReturnedtoEngDTE, TBL_QC_Review.SenttoPlanning, TBL_QC_Review.EngResubmitted, TBL_CWPData.PermitREQ, TBL_QC_Review.Comments, TBL_QC_Review.Shop, TBL_QC_Review.RFI1, TBL_QC_Review.RFI2, TBL_QC_Review.RFI3, TBL_QC_Review.RFI1answered, TBL_QC_Review.RFI2answered, TBL_QC_Review.RFI3answered, TBL_CWPData.Section, TBL_CWPData.Unit, TBL_CWPData.Engineer, TBL_CWPData.ITPRequired, TBL_CWPData.ITPCreated, TBL_CWPData.[Work Desc], TBL_CWPData.CRCGroup
FROM TBL_CWPData INNER JOIN TBL_QC_Review ON TBL_CWPData.[Work Order_ID] = TBL_QC_Review.[WorkOrder];

[June7]

Why do you have both tables in form RecordSource?

Should be main form bound to TBL_CWPData and subform bound to TBL_QC_Review.

However, doesn't seem to explain why there would be duplicate records in tables.

If you want to provide db for analysis, follow instructions at bottom of my post.