B
BLV 06
I am having trouble with one of the fields in my data entry form. The form
contains a number of subforms, each representing a table in the database.
The table all relate to one field, lets call it "code", in the primary table.
I need one of the data entry fields not to allow duplicate values. I
thought the easiest way to do this would be to index the "code" field in that
table so that duplicates are not allowed. The validation works, so when you
go to enter a 2nd entry in the new field it gives you an error box that
duplicates are not allowed (standard access error box) however, it does not
allow you to delete the 2nd entry, the same error box comes up again. I can
not how figure out how to get out of this loop without closing out of the
database, which isn't a very user-friendly option.
Does anyone have any suggestions?
contains a number of subforms, each representing a table in the database.
The table all relate to one field, lets call it "code", in the primary table.
I need one of the data entry fields not to allow duplicate values. I
thought the easiest way to do this would be to index the "code" field in that
table so that duplicates are not allowed. The validation works, so when you
go to enter a 2nd entry in the new field it gives you an error box that
duplicates are not allowed (standard access error box) however, it does not
allow you to delete the 2nd entry, the same error box comes up again. I can
not how figure out how to get out of this loop without closing out of the
database, which isn't a very user-friendly option.
Does anyone have any suggestions?