Access: Variable Creation?

Is it possible, using Access to create a unique alphanumeric variable field everytime a new record is entered?

In other words, everytime I enter a record, I want to assign a variable such as, KW1 to the first record, KW2 to the second record, and so on, and so forth.

Thanks for your assistance!

Hi !

I suppose your trying to do so in VB.

Maybe you could try using arrays.

You would then have something like

dim KW() as WhatEver

and then assign the value you want to preserve to a new element
of that array.

i.e. : KW(0) = value;

ciao!