I have a button on the main form, Form1, that opens another form, Form2, to the same record as the first form.
This code works fine when using the main table. The primary key is ID. I want to sort the data in the main table by Field1 using a query, Query1, and open Form2. I tried to change the...