How do I validate a field in Access to DEMAND unique values?
January 11, 2010 11:20 PM Subscribe
MS Access Filter: How do I set a validation rule for a field in a form or table so that Access will immediately recognize that the same value has been used before and tell the user to generate a unique value?
posted by man down under to Computers & Internet (4 answers total)
I'm using MS Access 2003
I want to have a field (Quote_Number) which serves as the primary key for the QuoteTable, but I want Access to tell me as soon as the focus tries to leave the field if the value is not unique.
As it is Indexed and does not allow duplicates in the table (or form version) Access tells me that it can't allow a duplicate value as the record is completed, but obviously I'd like to be informed of that before the whole Record has been filled in.
I don't want to simply use an Autonumber value, as I want to be able to customise the quote number's for various purposes, and have used an Input Mask to ensure it is a letter followed by a string of three numbers (L999).
This is a noob question, and will either be slap in the face easy to rectify or Google (if I knew what to search for), or horribly complex and it is only my ignorance that leads me to believe this should be simple...either way, I appreciate any help...