Avoid sorting of listbox after selection

[#1]

Hi,

I have a list box which contains the month names. I sorted it based on Month code using Expression sort. The values come sorted the first time, but after a selection is made, the values are sorted randomly. Is there a way to avoid sorting after a selection is made? Please let me know.

[preminqlik]

can i know expression which is used in sort tab ?

[preminqlik · Accepted solution]

I thinkn u may be busy ,

wite the expression in sort tab and arrange it as ascending,

=only({1}if(Month='Apr',1,

  if(Month='May',2,

  if(Month='Jun',3,

  if(Month='Jul',4,

  if(Month='Aug',5,

  if(Month='Sep',6,

  if(Month='Oct',7,

  if(Month='Nov',8,

  if(Month='Dec',9,

  if(Month='Jan',10,

  if(Month='Feb',11,

  if(Month='Mar',12)))))))))))))

hope this help you...

Regards

Premhas

[tresesco]

Go to general tab, enable 'Show as TreeView'

Or,

In the sort tab, uncheck sort by 'State' .

[#5]

Hi,

See the attachment.

[israrkhan]

Hi

as tresesco said,

'Show as TreeView'  sure will work, try it..

[CELAMBARASAN]

Uncheck the Sort by State option in Sort tab.

[#8]

Guys,

Extremely sorry for not replying. Was out of town. This worked perfectly just that I used only {1} MonthCode, where MonthCode is a column in my month table. Before this I tried un-checking all options (except Expression) but it didn't work. Also, Show as Tree View actually disables Sort by State and seems to be working as well. Thanks everyone who had replied to my question