Check for Record and Add If Necessary

  • Thread starter Matthew Grayson
  • Start date
M

Matthew Grayson

I've created a form which is connected to several tables.
Two of the fields are connected to a table of unique
values (names). After the user enters the data, I would
like a check to be performed to see if it is a duplicate
and if not, add it, if so, use the value from the table.

ANYBODY have any suggestions....


Matthew
 
T

tom

If the fields are truely unique, there's no reason to search for duplicates
- Access wouldn't allow duplicates...

Tom.
 
Top