Check for Record and Add If Necessary

  • Thread starter Thread starter Matthew Grayson
  • Start date 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
 
If the fields are truely unique, there's no reason to search for duplicates
- Access wouldn't allow duplicates...

Tom.
 
Back
Top