Data Order De-organize

[Benjamins via AccessMonster.com]

Hi,

I have a form that i created, when type in the info and details. Details is a
subform that can store multiple records. After entry, the record order de-
organize even it is sort by their id (the earliest record will have the
smallest id). The 3rd record became the 5th. I print the record and the
result is the same.

Does anyone know what is happening?

 

[Jeanette Cunningham]

Hi,
the order of records in the table doesn't matter. It makes no difference to
the data at all. A table is not meant to keep the records in any particular
order.
Before you create any forms, or reports to print the data, create a query
based on the table. In the query you can sort the records into the order
you want.
If you want to display the records on a form in order, base the form on the
query.
Do the same for the report you want to print.

Jeanette Cunningham

 

[Benjamins via AccessMonster.com]

Thanks for your advise, i will give it a try.

Hi,
the order of records in the table doesn't matter. It makes no difference to
the data at all. A table is not meant to keep the records in any particular
order.
Before you create any forms, or reports to print the data, create a query
based on the table. In the query you can sort the records into the order
you want.
If you want to display the records on a form in order, base the form on the
query.
Do the same for the report you want to print.

Jeanette Cunningham

Hi,

[quoted text clipped - 6 lines]

Does anyone know what is happening?