need a "session stamp"

[Guest]

form based on table

someone can enter data with variable record volume..i.e. 1 or 21 records...

the record will have a field for the "session stamp" to uniquely identify
those records put in during one session (i.e it is loosely enforced...just
an "enter" button that will refresh the screen is sufficient)

first I threw in Now() but discovered each record was timestamped by the
nanosecond so records of one session had different values for different
records of that session...which will disable our ability to reassemble by
sessions....

don't want user to enter the value


as they tab thru each record I have the code on a mandatory field that
'AfterUpdate' the SessionID=__________________

need a value generator and to make it change (nonrepeating)when the form
refreshes (closes/reopens)....

would very much welcome advice....I think it's easy but am kind of stumped
at the moment....need to go have a coffee and clear the fog....

 

[Guest]

answered my own question.

Did use the Now() timestamp but 'froze' it by using a second unbound with:
= Right([TimeStampField],20)

which returns a nice unique text string...... and stays fixed

and then the next time the form is opened the value will always be different
and unique...