I have a form in which I enter information to create a purchase order.
The Main form has basic information, like vendor, shipping location, job, po number etc.

There is a subform that links to another table which records the items purchased on that one PO.

I have a button that when I click it, I'm able to see a print preview of that report, which indeed displays all the necessary information. But there lies my problem

When the Items purchased are displayed, they're not shown in the same order as they're entered in my form (this is important for the purpose of this database). I can't quite determine how access is sorting this.

Can anyone suggest a way to force the report to show the listing in the same order as entered in the form?

See the screenshot

Put a timestamp column on your table and sort by that.

Thanks goergedwilkinson
I was in the process of implementing your suggestion when I realized, my PoItems table already has a auto-number primary key, which inevitably increases every time I enter a new line item... so I used it instead of a fimestamp... Same method, just different data type...

Thanks

Exactly. Glad you had the foresight to implement that.