View Single Post
  #1 (permalink)  
Old January 18th, 2007, 12:49 PM
donevco donevco is offline
Authorized User
 
Join Date: Nov 2006
Location: Evergreen, CO, USA.
Posts: 35
Thanks: 0
Thanked 0 Times in 0 Posts
Default Duplicate Primary Key

I'm addressing the situation when the user accidently enters a duplicate record. Assess takes them through a clumsy process, advising that the record can't be entered, ending by closing the form.

This table has a single primary key field. I'd like to check for a duplicate as soon as the field is entered, warn the user, and allow her to back out or, possible, reset the form. Anybody have some good code?