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 am trying to right a formula that will force a field value to be unique if another field is equal to 'yes'
example: if field1=yes, than field2 must be unique, else field2 can be any value.
Any help would be appreciated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.