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! http://www.access-programmers.co.uk/ubb/smile.gif http://www.access-programmers.co.uk/ubb/smile.gif

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