Subforms sorting rows
Is it possible to sort the rows in a subform?
I have an application where the user uses a subform to record the steps in a process. They enter the details of Step 1 , later they add the details of Step 2 and so on for step 3, 4 & 5. When I edit the form the rows in the subform are in a random order.
The best solution is for the rows to show in the order that I specify in the subform view. The second best is to use the date & time each row was entered as the default sort order.
Any work arounds?
Herb Wexler
I have an application where the user uses a subform to record the steps in a process. They enter the details of Step 1 , later they add the details of Step 2 and so on for step 3, 4 & 5. When I edit the form the rows in the subform are in a random order.
The best solution is for the rows to show in the order that I specify in the subform view. The second best is to use the date & time each row was entered as the default sort order.
Any work arounds?
Herb Wexler