Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check for Unique Values

Status
Not open for further replies.

rsamson

Programmer
Feb 22, 2002
4
US
I have a number of fields that I want to be unique if they are filled in. I am fairly certain this is a macro on data change, I just can't seem to put it together. Setting the validation to unique doesn't work for me because the form "barks" at me if I leave a field marked unique empty.
 
I do not believe that doing a Find on each field to see if it is unique will work satisfactorily from the performance point-of-view. Scripting the lookups would be the only way to go.

Sue Sloan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top