Printing report from form

[bruno1]

I have an invoice report that prints from a query base on a table. I input details from a form based on the table. The report details are printed in what seems to be a random order from the form input. How can I get the report to print the details in the same order as on the form.

 

[jrbarnett]

You need to sort the data in the report in the same order as it was entered onto the form - so perhaps you need something like an invisible autonumber field on the form, which you can then sort the data on in the report (again, you don't have to display it).

John

 

[dhookom]

Reports use the Sorting and Grouping dialog to specify the order records are displayed in your report. Reports also have an Order By property but I never use it and don't recommend that others use it.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]