No Duplicates Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a control on a form that won't allow a duplicate to be entered (and it
needs to be that way). I would like an error routine that stops the user's
input and undoes the user's input, along with an error message that indicates
it was a duplicate value. The control is call "Item_No". I know I'm asking
a lot of questions, but I truly don't know the answers.
 
You can trap this in the Form's On Error event. Put in the following code:
If DataErr = 3022 Then
MsgBox "Duplicates not allowed"
Response = acDataErrContinue
Me.Undo
End If

HTH,
Barry
 

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

Preventing Duplicate Entries 1
No Duplicates 3
Access Auto Matching Duplicates? 0
Trapping the 'no duplicate values in a table' error 2
Duplicate record in Form and Subform 0
Compound Index 1
Duplicated Invoice number checking when leave the field 4
Problem with code to catch duplicate Primay Key 22

Back
Top