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.
 
You must log in or register to reply here.

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

Update Two Tables Using One Form Contents 0
Help with form load 5
Check for Duplicate Records 7
checking for existing record 3
Check for duplicate with multiple criteria 4
Duplicating records 3
Using Unique Values and Unique Records 13
On click add record 1

Back
Top