I want to sort a datafield by three different columns, C, G, and H. C is fiber number 1-864, G, is Distance in Feet, H, is a status column, and that one I would want only the “Live” ones on the top. Update, I have the code not erroring, but it isn’t working either. The captions of the commandbutton are not updating which may be causing the sorting to not work because the Fiber column is already sorted before being imported.
Update: The Sorting is working. When I manually manipulate the Fiber Case with the other column numbers, the areas get sorted correctly. It’s the Updating of the Caption to cycle through the different sort Cases that is the issue.

I want to sort a datafield by three different columns, C, G, and H. C is fiber number 1-864, G, is Distance in Feet, H, is a status column, and that one I would want only the “Live” ones on the top. Update, I have the code not erroring, but it isn’t working either. The captions of the commandbutton are not updating which may be causing the sorting to not work because the Fiber column is already sorted before being imported.
Update: The Sorting is working. When I manually manipulate the Fiber Case with the other column numbers, the areas get sorted correctly. It’s the Updating of the Caption to cycle through the different sort Cases that is the issue.

I want to sort a datafield by three different columns, C, G, and H. C is fiber number 1-864, G, is Distance in Feet, H, is a status column, and that one I would want only the “Live” ones on the top. Update, I have the code not erroring, but it isn’t working either. The captions of the commandbutton are not updating which may be causing the sorting to not work because the Fiber column is already sorted before being imported.
Update: The Sorting is working. When I manually manipulate the Fiber Case with the other column numbers, the areas get sorted correctly. It’s the Updating of the Caption to cycle through the different sort Cases that is the issue.

I want to sort a datafield by three different columns, C, G, and H. C is fiber number 1-864, G, is Distance in Feet, H, is a status column, and that one I would want only the “Live” ones on the top. Update, I have the code not erroring, but it isn’t working either. The captions of the commandbutton are not updating which may be causing the sorting to not work because the Fiber column is already sorted before being imported.
Update: The Sorting is working. When I manually manipulate the Fiber Case with the other column numbers, the areas get sorted correctly. It’s the Updating of the Caption to cycle through the different sort Cases that is the issue.

I want to sort a datafield by three different columns, C, G, and H. C is fiber number 1-864, G, is Distance in Feet, H, is a status column, and that one I would want only the “Live” ones on the top. Update, I have the code not erroring, but it isn’t working either. The captions of the commandbutton are not updating which may be causing the sorting to not work because the Fiber column is already sorted before being imported.
Update: The Sorting is working. When I manually manipulate the Fiber Case with the other column numbers, the areas get sorted correctly. It’s the Updating of the Caption to cycle through the different sort Cases that is the issue.

I want to sort a datafield by three different columns, C, G, and H. C is fiber number 1-864, G, is Distance in Feet, H, is a status column, and that one I would want only the “Live” ones on the top. Update, I have the code not erroring, but it isn’t working either. The captions of the commandbutton are not updating which may be causing the sorting to not work because the Fiber column is already sorted before being imported.
Update: The Sorting is working. When I manually manipulate the Fiber Case with the other column numbers, the areas get sorted correctly. It’s the Updating of the Caption to cycle through the different sort Cases that is the issue.

I want to sort a datafield by three different columns, C, G, and H. C is fiber number 1-864, G, is Distance in Feet, H, is a status column, and that one I would want only the “Live” ones on the top. Update, I have the code not erroring, but it isn’t working either. The captions of the commandbutton are not updating which may be causing the sorting to not work because the Fiber column is already sorted before being imported.
Update: The Sorting is working. When I manually manipulate the Fiber Case with the other column numbers, the areas get sorted correctly. It’s the Updating of the Caption to cycle through the different sort Cases that is the issue.