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.
 

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

Is this possible? 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Help with form load 5
Duplicating records 3
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Data entry for a table from a form 2
Data entry VBA 1
Data entry to table from a form 0

Top