check Duplicate

[irsmalik]

Hello friends, I am stuck with Duplicate problem. So looking for help.

I have a data entry form (name is "Review Entry From") and I want to check 2 field from 2 different tables.

1. Check Drawing and Rev from Process table and if both conditions are Not Ok then message "Drawing with this Rev dose not Exis".

2. Check Drawing and Rev from Reveiw table and if both condition are found OK... the message should be "Drawing with this Rev already exist".

Both checks should be on form.... form name is "Review Entry Form"
Thanks in advance from all friends.
Irshad Ahmed

[Rabbit]

Create a unique index on the fields in the tables and you won't have to do any checks. Access will enforce it itself and not allow duplicates to get put into the table.