Form entry order changes

[Rick]

I key items in the form and then later check and the
order has changed..what causes some of the rows/records
to change their order of when I keyed in the form? I
need to keep them in the same order.

 

[Howard Brody]

If you have a PrimaryKey in the table, it will sort by
thay first, then by any indexes you have selected.

If you want to be able to sort by the order entered, add
an autonumber field to the table. That will numebr each
record in the order it is entered and gives you a field to
sort by.

Hope this helps!

Howard Brody