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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check for duplicate with multiple criteria 4
Duplicate Entries 1
Access Compare records in same access table 0
Automatically highlight duplicate value 1
Duplicate value in one field into another field 1
Duplicating a field that is set to "allow multiple values"...How? 1
Duplicate checking... 2
Check for Duplicate Records 7

Back
Top