RECORDS IN FORM ARE DIFFERENT SEQUENTIALLY IN TABLE

[Guest]

RECORDS IN TABLE ARE SEQUENTIAL, BUT THE SAME RECORDS IN THE FORM ARE NOT.
I.E. 1 2 4 5 8 3 6 ECT

 

[Rick Brandt]

RECORDS IN TABLE ARE SEQUENTIAL, BUT THE SAME RECORDS IN THE FORM ARE
NOT. I.E. 1 2 4 5 8 3 6 ECT

Tables have no particular order and when you bind a form or report directly
to a table you are never guaranteed that the records will be retrieved in
any particular order. When the order matters use a query with an explicit
sort applied (forms) or apply the desired sort in the Sorting and Grouping
dialog (reports).

You can also set the sort order on the form, but that is easily changed or
disturbed by user actions.