My problem start from here. for example i have 4 records as below :
TCode TName
-------------
1 Wname
2 Aname
3 Uname
4 Hname
if i set order to TCode and i stay on TCode=3 in list box , so i change the order to TName, i want to stay on TCode=3 again, but it changed to another TCode.In the Valid of your option group:
IF This.Value = 1
SET ORDER TO TAG TCode IN MyAlias
ELSE
SET ORDER TO TAG TName IN MyAlias
ENDIF
WITH This.Parent.MyListBox
lnValue = .Value
.Requery()
.Value = lnValue
ENDWITH