Richard, I'm just wondering if I need to change something in the subform. When I add a new order, I notice that the order goes to the front of the line rather than the last. For example, If I have 4 orders listed on the record label as 1-4, I add a new order #5, and when I finish and close the form it will open with the most recent order as opposed to the very first one created. Thanks, Ken
Do you have a sort order specified? If so, then that's how your form or report's going to sort.
Kenneth WykoffOP
@Reply 2 years ago
To be honest, I am not sure. Since we deleted all the other orders and info and started fresh I have now way of finding out now. If I want the the orders in the order form to go in sequence starting from the lowest to the highest, I just sort the OrderID that way I am assuming?
Kevin Robertson
@Reply 2 years ago
I would sort by OrderDate (earliest orders first).
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 9.
