I have a listbox in my form and a radiobutton with two option.
I fill the listbox with a free table records (TCode N(5,0), TName C(15))
My free table is ordered based on Tcode and Tname.
When i select OPtiongroup1.option1 i want to show recordes based on Tcode order and when i select OPtiongroup1.option2 i want to show recordes based on Tname order and i want to last selected item in listbox dont changed and record pointer stay at previous record in table.
how can i do thisOff the top of my head and untested:
Set up your list box like this:
RowSourceType = 6-Fields
RowSOurce = MyALias.TName, 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
This.Parent.MyListBox.Requery()