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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
Back
Top