Adding New Records ONLY

[OrWolf]

I have a form that is connected to a database. I'm using a SQL INSERT INTO command to add new records. However it's allowing duplicates to be input and I'd like to avoid this. Any ideas on how I can limit this?

 

[phuctran]

One easy way is adding one ID field (autonumber field) in your database. Insert then check for error, if has error of duplicated records then display error message.

Other way is you have to "select from ..." to see if you get any records from the database before Inserting.

 

[link9]

Another approach without error messages --

As phuctran suggested, just add a primary key field -- which would distinguish what was a duplicate field, and then in the code, set 'on error resume next' and just go to town on your inserts. Only uniques will be added, and no error messages will be thrown -- that is, of course, unless you want them.