Selection in month is cleared with clear button for individual list box

[#1]

Hi Everyone,

I have created a trigger on the month field and monthnum field. That if i select a month example APR the all the months from JAN to APR are selected.

='('&Concat({<Month,MonthNum={"<=$(=MonthNum)"}>}Month,'|')&')'

But when i use the clear field of a list box along with the list box of that particular field the field month also gets cleared.

I want the selection in the field month to be constant if i use any of the clear field on the list boxes.

Thanks in advance.

Regards,

Akshay

[awhitfield]

Hi Akshay,

you could try:

Select 1 item in you list box, select properties and then tick 'Always One Selected Value'

HTH Andy

[stigchel]

You could look at locking the field, but In general I would suggest not to rely on a listbox having several selections, but move that logic to your calculations with the help of set analysis e.g.

Sum({<Month,MonthNum={"<=$(=Max(MonthNum))"}>} Sales)