Prevent duplicates using a data control

[DKasler]

Is there a way to prevent a duplicate record from being saved using the MS Data control? If not is it possible to do it using ADODB and how?

The only way I've seen is using DAO and im not really sure how to do that.

[RobDog888]

Since you are using the data control you will run into many issues using this bound control.
I suggest using ADO. Here is a good ADO Tutorial.

If your getting duplicates then you need to set properties in your table design to dis-allow this. Then you can error trap.

[DKasler]

If your getting duplicates then you need to set properties in your table design to dis-allow this. Then you can error trap.

ill try that. thanks