Check for duplicates

  • Thread starter Thread starter Claire
  • Start date Start date
C

Claire

Hi everybody.

Access 2000

I need to compare values entered into a calculated text
field to see if a duplicate has been entered.

The calculated text field (txtDisposition) is a file
number created by concatenating two values entered
previously on the form. When the user exits the
strDispositionNumber field I would like Access to check
the calculated txtDisposition field to make sure that
there are no duplicates with other data values in that
field.

Some day I will learn VBA..........

Thanks in advance,
Claire
 
Claire,

Check my reply to "Bob" 's posting titled "Checking for duplicate on hitting
the enter" in the tablesdbdesing NG, dated March 03.

Do embark on VBA, it will change your life (with the PC)!

HTH,
Nikos
 
Back
Top