Lost selection in multibox when activating other sheet
Hello,
One of the sheets in a QV document has a multibox that displays one field defined as an expression.
The expression is similar to Year & '-' & Num(Month, 00), concatenating year and month to be able to select both with a single selection.
The matter is that it allows the selection in the sheet, selecting values for Year and Month, but this selected values disappear when activating another sheet, while the rest of the selected values from fields persist.
I believed that it should be related to the filtered expression, but adding Year and Month as fields in the same multibox, they are also lost when activating another sheet.
Is there a way for not to loose these selected fields from the multibox as well as the rest of selected fields from other multiboxes in the same sheet ?
