I have created a form with an OEDB Database connection to an Access 2003 database table. The connection is good. It pulls the right data fields from the correct Access table. But...it pulls the records in an order other than how they are sorted in the Access table.
I care about the order because the data in the table has been gererated in a random order for audit sampling purposes and I need to print the forms with the data from the table in the same record order.
What controls the order in which records are pulled in this type of connection? Or to ask another way...how do I control the order in which records are pulled?