What determines which record is displayed

[mitchem1]

What determines which record is displayed when my form opens? It currently displays the first record (ID = 1) from the record source (table). I changed the sort on the ID column to descending, hoping the form would show the last record when opened. It still shows the first. What am I missing here? Thanks.

 

[Rich]

Since you've already created the form you'll have to change the sort order there, right click on the field and select the option you want.

 

[mitchem1]

OK, but what could have I done prior to creating the form to get the desired results?

 

[Fornatian]

1. Apply a sort order to the table properties so that an alternate sort order is applied to the table.

2. Apply a sort order to a query to change the order of the returned recordset.

3. Give users the ability to manipulate the sort order themselves by dynamically creating the SQL code dependent on user selections and input.

4. Display the data in a datasheet, and allow the user to select sort A-Z/Z-A by right clicking on the column header.

Ian