Autonumber problem with sub-form

[andy_dyer]

Hi,

I have a form that works fine when accessed on it's own.

I have placed this as a subform within a larger form. Now whenever a new entry is added it repeats the same autonumber as on the last entry and then I get a barrell load of error messages about duplicating my primary key...

Any ideas on what i have done wrong?

 

[DeborahP]

I don't think you can use a subform unless there is a primary key defined not as a auto number. The primary keys have to match perfectly for the sub form to do it's job.

Subforms can be tricky and I have learned from experience about matching the keys so the data is stored correctly.

Good Luck.

Deborah