I have a problem with a database which I've recently separated into several
related tables. I have a main data entry form, which has several subforms
on it on tabbed pages. The first subform is actually part of the main data
table, however, when I try to add new data to the form all is OK until I
reach the first tab page which has specific data (still on the main table),
when you try to add data to this part of the form an error message relating
to duplicate values in fields, indexes or relationships occurs.
However, this doesn't happen if you put info in the main part of the form.
Close the form. Open the form again and add the data on the subform now.
All is OK.
I know this must be something simple but I just can't work it out.
Any help???
D