Order of record changes after entry?

[Rick]

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

 

[Gary Miller]

The order in the table is irrelevant as it is just a
container. Use the OrderBy property of your form or base the
form on a query where you can set the sort order as needed.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________