how to Check the dup.rec in the entry point

HI,

In the form, after entering the value in the text box, how can i check that value for the duplication in the Table.

You could use a SQL statement:

"SELECT * FROM tablename WHERE fieldname = " & datayouarechecking

Then check for not BOF and not EOF

Thanks man,

tell me which is the best even to put the checking
LostFocus or Validate event.