Forms & Sub-forms (1 Viewer)

[EricH]

I have created a form with a subform.

When I enter records in the subform (eg 1 record on main form has 3 records on subform)I end up with 3 identical records in main form each with 3 records in subform.

Is that clear??

The linked Master Fields & Child Fields looks OK.

I'm linking SALESID.MainForm(Autonumber) to SALESID.SubForm(Number-Long Integer).

 

[charityg]

what is your main forms data source?

 

[EricH]

Problem solved!!!!

I had included the table for the subform in the query for the main form.

Thanks for your help.