I have created a form with 2 subforms made from forms from three tables.
The first table has a primary key and the others do not .
From the main table I have a name combobox linked by ID to the first subform. this looks up the second table and enters data that never changes for viewing.
The third subform I hope will allow data entry, .i.e other journeys not in the lookup list.
However, when I click the name and the viewing data changes I cannot close the form without an error message. This reads:
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship."
With the name and first sunform I just want the data to show for viewing not change in the table the only place the information will change is in the third subform. However, I get this message even when I have not entered date in the third form.
Can anyone help.
Regards
The first table has a primary key and the others do not .
From the main table I have a name combobox linked by ID to the first subform. this looks up the second table and enters data that never changes for viewing.
The third subform I hope will allow data entry, .i.e other journeys not in the lookup list.
However, when I click the name and the viewing data changes I cannot close the form without an error message. This reads:
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship."
With the name and first sunform I just want the data to show for viewing not change in the table the only place the information will change is in the third subform. However, I get this message even when I have not entered date in the third form.
Can anyone help.
Regards