Sorting on a Subform

[Guest]

I have a form which contains a subform...pretty basic...except when I enter
information in my subform and then preview the information it sorts the
multiple fields of information. Is there a way I can prevent sorting to this
subform so that however I enter the information that it will appear on my
form/report as I entered it.

Any help would be appreciated.

Thanks Bunches!!!!

 

[John W. Vinson]

I have a form which contains a subform...pretty basic...except when I enter
information in my subform and then preview the information it sorts the
multiple fields of information. Is there a way I can prevent sorting to this
subform so that however I enter the information that it will appear on my
form/report as I entered it.

Any help would be appreciated.

Thanks Bunches!!!!

The data is not stored in the subform. It's stored in a Table - and tables
have no meaningful order. Think of a table as a sack full of data.

If you want information presented in a particular order you must - no option!
- use a Query sorting the data, or (for a Report) use the Report's Sorting and
Grouping option to sort the records by the value of some field in the table.

If you want to maintain the order of records as entered, you can use a
sequential Autonumber or a Date/Time field defaulting to =Now() to timestamp
each entry. Base the form on a Query sorted by this field, and use this field
in your Report's sorting and grouping dialog.

John W. Vinson [MVP]