Prevent duplicate record from being written to a table
I have a datasheet form that has 5 fields. If the user double clicks the record selector the record is written to a separate table. But if the user d/c again and that record has already been written to the table I don't want to allow it if it is an exact duplicate (all 5 fields). How can I prevent this from being allowed?