Unique Combinations

[Little_Man22]

I have a form with 5 fields. No one field is unique, however, the combination of all 5 fields should never be listed twice.

I want to have some error checking on the form so that when someone presses the 'Add Record' button it looks through the table and makes sure there is no record where A = A & B=B & C=C & D=D & E=E....

How do I accomplish this?

Thanks,
-Ryan.

 

[UniqueTII]

Isn't there a type of query that checks for duplicates?

 

[Pat Hartman]

Even though these fields are not part of the table's primary key, you can still establish a unique index comprised of the 5 fields. Access will then not allow the record to be saved if this set of fields would be duplicated.