order of records in report deviates from order of records in form

[Absolute_Beginner]

Hello everybody.

I’ve got the following issue with my report:

The order of the records displayed in my report deviates form the order of the records displayed in my subform. There are a couple of things I’ve already tried, but as I am not a native speaker of English I would not be able to use the correct technical terms here.

Therefore, I will upload a sample database. The report in question is called “rptSitzung”. It is opened as follows:

“open database” (the button on the auto entry form) –> “print preview”.

The subform that contains the records that are not displayed in the correct order in the report is called “ufoThemen2”, and belongs to the form “frmSitzung4”.

I would greatly appreciate your assistance in sorting out this problem! please let me know if you require any further information!

 

[vbaInet]

You are using a Table as the Record Source of your form. Tables aren't sorted in any order, but in most cases they are displayed in the order in which the records were entered.

To keep a consistent ordering between the form and the report, explicitly add a Sort By in the queries that the report and form are based on. So, create a query for your form too, apply a sort in the query and set the query as the Record Source of your form. Edit the Record Source of your report and set a Sort on the field you would like it to be ordered by. A report also has a Sorting and Grouping functionality, you can use that too.

 

[Absolute_Beginner]

Thank you very much for your assistance! I was able to solve the problem using the information you provided.

 

[vbaInet]

Happy to hear!