Hi All, I'm wondering if you can help me out, i'm designing a database that uses a form to input the users data, they are then assigned a unique code.

i have used the folioing formula to generate the random alphanumeric code but when the next entry is entered all of the codes change (I know this is because they are randomly generated etc).

so using =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(10,99) how do i get it to stop it randomly assigning a new code every time a new entry is entered?

Much appreciated guys

Dan