I need to do a macro which loop on a list on field value in a certain order as example below:
I want to select in the order of MySortField the value in the field MyField.
Is it possible to do in macro with getPossibleValues with others functions without use a list box?
If not, how can I do the same thing in looping on a list box object containing field Value of MyField order by MysortField ? What macro function use to do this in using directly this graphic object.
In the second case, I have seen a little problem : sort by expression in my list box don't work on "gray" value (exclude of possible values list). they are all at the end of the available values which are correctly sorted.
I am having the same issue where I need to load an alpha numeric field (Field #1) and have it load/sorted by a numeric sort field (Field #2). The sort order of (Field #1) is unique to each person's ID number (Field #3). I have tried what I believe is your solution of using a .Select, but can't get the sort order to change. Can you share a little code.