record sort in Form

[M]

The records in my form seem to be sorted alphanumerically
by ExpID(pk). I want them to be sorted oldest record to
most recent because folks make use of Ctrl/' to copy
values from last record. Does this mean I need to add a
autonumber field or how else would I accomplish what I'm
trying to do?

 

[Wayne Morgan]

No, don't rely on autonumbers for anything other than a unique record ID.
You can either create your own incrementing number field or include a
date/time field that shows when the record was created. Sort on either of
these fields.