Microsoft access order by form

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? I have the same question Report abuse. Details required :. Cancel Submit.

Scottgem MVP. First, let me recommend that you take a look at the Northwinds sample database that comes with Access. It is an order entry system and you can learn by the examples. Second, unless customers only order ONE product per order, you need another table, OrderDetails, to show the line items within the order.

Finally, the Combobox wizard will create the combos the way you want them. By default you can select the Product Description or Customer name and the wizard add the key column and hide it. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.

Emily K In reply to Scottgem's post on September 21, If you have set up an order details table, how do you get the combobox to work so you can enter multiple different lines on the order form. InvoiceNumber As the field is an autonum the form opens, nothing is displayed. I want to reverse that so that the form will display the last record first at record How can I do this? Follow Post Reply. 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! Order By - Table1. Post Reply.