L
ladybug via AccessMonster.com
I have a subform with a date field in the header. This form is set to
continuous so that there can be multiple entries per date. The date field is
autopopulated based on another text box in the main form. The date populates
for the first entry, but when I tab to the next entry I get an error:
The changes you requested to the table were not successful because they would
create duplicate values in the index, primary key, or relationship. Change
the data in the field or fields that contain duplicate data, remove the index,
or redifine the index to permit duplicate entries and try again.
The date does not autopopulate when I tab to the next entry and I think that
is what is causing the problem. How do I get the date to continue popluating
throughout multiple entries?
continuous so that there can be multiple entries per date. The date field is
autopopulated based on another text box in the main form. The date populates
for the first entry, but when I tab to the next entry I get an error:
The changes you requested to the table were not successful because they would
create duplicate values in the index, primary key, or relationship. Change
the data in the field or fields that contain duplicate data, remove the index,
or redifine the index to permit duplicate entries and try again.
The date does not autopopulate when I tab to the next entry and I think that
is what is causing the problem. How do I get the date to continue popluating
throughout multiple entries?