Next/Previous Record Buttons

[davegri]

but really my question just boils down to whether or not I can scroll between orders in my View All Form

Look at post #14 again. It shows what your form can see and only what it can see. It's all ONE order. When you scroll you scroll thru the four rows for THAT order.

[ahuffman24]

I understand that, and that is what I DON'T want to happen. I want to scroll order to order, not through all of the serial numbers under one order

[davegri]

I want to scroll order to order, not through all of the serial numbers under one order

Then you'll have to construct your form's recordsource to have only one row per order. What would you expect the detail section should show in that case?

[ahuffman24]

The details section will look exactly the same, and when I click the "Next Record" button, it will just change all of the information on the screen to the next record's info. So, (just purely for example), if I am viewing and order from Walmart and it is Order #1, all of the details of Order #1 will be on the screen. Then, if I click the "Next Record" button, it will take me to Order #2, and all of Order #2's item number info, serial number info, etc will show up on the screen. Does that make sense?

[davegri]

The details section will look exactly the same, and when I click the "Next Record" button, it will just change all of the information on the screen to the next record's info. So, (just purely for example), if I am viewing and order from Walmart and it is Order #1, all of the details of Order #1 will be on the screen. Then, if I click the "Next Record" button, it will take me to Order #2, and all of Order #2's item number info, serial number info, etc will show up on the screen. Does that make sense?

And that's exactly what the database I submitted in post#10 does. You cannot do what you want without the form/subform arrangement.
That's my final reply.
Good luck with your project.

[June7]

You can display order details in a conditional listbox but then you would not be able to add/edit order details on this form. This would be strictly to display, no details data entry/edit.