Macro next/previous record buttons

[ahuffman24]

Hi,

I am using Access 2016. I have a database that keeps track of orders and info about those orders. One of the sections of the database allows the user to select a specific order to view the details of. However, each order may have more than 1 item on it. For example, the picture below shows order number 55555 has both item 4.00 and 5.00:



The user can then choose which item to inspect for the order, and it brings them to this page:





As you can see in the above picture, I have two buttons with a left and right arrow on them. I want those arrows to scroll between each of the items on the chosen order. Keeping with the previous example, if the user chooses to view the details of item 4.00 on order 55555, then if they click the right arrow button, it should display the information for item 5.00 of order 55555. Right now, I have the buttons set up in macros to scroll to the "next" record for the right arrow button and the "previous" record for the left arrow button, but they only scroll through the serial numbers of the current order instead of scrolling order to order. To clarify, if I am on order 55555 of item 4.00 and I click the right arrow button, the next serial number will become highlighted in the subform, but what I want the arrow to do is to take me to the details of order 55555 of item 5.00. Is there a way I can make this happen?

[rpeare]

... why not post this on your original thread? It's the same question, just a restatement of what you need.

[ahuffman24]

I did not want to confuse anyone because I changed my form and am having a slightly different issue now than what I described in the other thread

[rpeare]

post back your current version please if you still need help with this.