how to check whether the entered data is present in table or not

A

anand

Hi
can any one help me hoe to check whether the data entered in the text box is
already present in the ms access (mdb) table to avoid duplication.
I have a table and a form to enter data in to the table .
Duplicate values should not be entered.I am new to ms access.
Please help me
 
K

Keith Wilby

anand said:
Hi
can any one help me hoe to check whether the data entered in the text box
is
already present in the ms access (mdb) table to avoid duplication.
I have a table and a form to enter data in to the table .
Duplicate values should not be entered.I am new to ms access.
Please help me
Click to expand...

Set the field index to not allow duplicates at table level.

Regards,
Keith.
www.keithwilby.com
 
Y

Yanick

If you set your table primary key and your form is bound to either a query
(based on your table) or the table it-self, an automatic error message will
occurred if duplicate is created.
 
Top