Auto-Sorting when opening a form?

[Benjamin Bolduc]

Hi Everyone
I have a form in my DB that has a subform that holds all of the Inventory transactions for the labels I keep track of. Everything works fine except every time I open the form and go to a product with more than one transaction, I notice all the records are all jumbled up. I need them to be sorted by date, but I cant find an option to do that in Form properties or anything. How do I keep my records from moving around on me?

Thanks!

 

[Jack Cowley]

Base the forms on a query and sort on the dates...