I have a table that data will be entered into through a form. On clicking the control I need to generate a unique (non repeating) five digit whole number for the new entry. This number is converted to a string as it will be concatenated with two other strings later.

I am setting up the action to generate the random number, convert to string, then it will compare with existing records in the field and if matches it will run again. If it does not match any records it is to append the new record.

I'm totally stumped on how to get the formula result into the table.

Disregard. I had a mental block from thinking too much, needed more sleep and less caffeine.