Save record sequence number from form

Hi,
I posted this earlier but it never appeared.
I have a continuous form that displays 4 fields from a table. The form also
has sort buttons which sorts the records in the form based on the sort
selected. My table also has a field called “sequence number�. Based on the
sort that is selected I would like to save the record sequence number for
each record based on the order that the records appear in the form. In
other words the record that appears first in the form would have a sequence
number of 1 stored for that record in the table, the second record would have
a sequence number of 2, etc.
Is this possible and if so can some help me with the code.
Thanks in advance,