Using Access 2003, I use a form to enter information such as customer name, etc. Once I enter a new customer I would like the order of the customers to reorder automatically by customer name. I have built a query as the source of the form and have the customer name set to sort. When I enter the new customer it remains the last record until I do a requery by using the shift F9 keys or exit the form and reenter.
Thanks
Start Free Trial
