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.