Duplicate SSN

  • Thread starter Thread starter TimH
  • Start date Start date
T

TimH

I have a table where SSN is a unique field and No Duplicates are allowed, the
Population has grown beyond a query to quickly see if the new entry is a
duplicate.
How do I set up a code to show a msgBox with SSN that start with the first
digit and continue to match untill either it is a new or the duplicate can be
seen on the msgBox?

As always Thank you for the answer in advance.
 
TimH said:
I have a table where SSN is a unique field and No Duplicates are allowed, the
Population has grown beyond a query to quickly see if the new entry is a
duplicate.
How do I set up a code to show a msgBox with SSN that start with the first
digit and continue to match untill either it is a new or the duplicate can be
seen on the msgBox?

As always Thank you for the answer in advance.
Click to expand...

I may be missing the point here but if you have the field set to no dups
then they won't be allowed, period. A message box will automatically pop
up saying that the field will not accept duplicates.

gls858
 
I have a table where SSN is a unique field and No Duplicates are allowed, the
Population has grown beyond a query to quickly see if the new entry is a
duplicate.
How do I set up a code to show a msgBox with SSN that start with the first
digit and continue to match untill either it is a new or the duplicate can be
seen on the msgBox?

As always Thank you for the answer in advance.
Click to expand...

A Combo Box with its autocomplete feature on (and it's on by default) will
"type ahead" and show you the match or matches as you type.
 
Back
Top