MS ACCESS FORMS using ORDERBY with [fieldname] in descending order

[astrid702]

In MS ACCESS version 2003 I have a form that is based on a table. I have indicated that I want the form to display the table content in the order of the tracking id number (InvoiceNumber) which is an autonumber field.

In detail view of my form, I select the upper left corner black box properties to get to:

Form - Properties
Record Source - Table1
Order By - Table1.InvoiceN umber

As the field is an autonum the form opens, nothing is displayed. I roll the wheel on the mouse and the default goes in ASCENDING order beginning at record #1. I want to reverse that so that the form will display the last record first at record #7046. How can I do this? - thanks A.

[malcolmk]

if you open your form then apply filter descending, save your form. Next time it opens it will list items in descending order however, the autonumber new record will still appear at the bottom of the screen so you would (if you had many records) have to scroll down. What's so important about having the last record appear at the top of the list? Why not just goto last record entered when form is opened, easier plus you see the last records entered right away!
Have an idea of getting around this but don't seea point to doing so!

[TheSmileyCoder]

Hi and welcome to BYTES.

You can change your orderby to:

Order By - Table1.InvoiceNumber DESC

where DESC stands for descending.

Please note that we have a specific access forum on Bytes: Access and VBA