Hello,
I have a form that I use to create new entries for my data table storing information on people. Each person is assigned a unique alphanumeric code. As soon as the user has entered an alphanumeric code into this field, I would like to check if it is unique.
Right now, I have set the field itself to unique - yes and required - yes. However, the uniqueness of the value seems to be checked only after I finish entering all the data which is too late for me.
Would it be possible to either do that with a macro or with a validation rule? Because the validation rule seems to be checked immediately after entering the value...
Best,
Max
I have a form that I use to create new entries for my data table storing information on people. Each person is assigned a unique alphanumeric code. As soon as the user has entered an alphanumeric code into this field, I would like to check if it is unique.
Right now, I have set the field itself to unique - yes and required - yes. However, the uniqueness of the value seems to be checked only after I finish entering all the data which is too late for me.
Would it be possible to either do that with a macro or with a validation rule? Because the validation rule seems to be checked immediately after entering the value...
Best,
Max