Losing the recordset

[dalacarelia_196]

Hello out there

I am using search in my gallery , it works fine , and i can go to my edit page and edit 

SortByColumns(Search(CRMAktiv;TextInput2_1.Text;"Title";"Handledare";"Stad";"Program";"Notering";"Epost";"Tel";"OData__x00c5_rskurs_Elev");"aterkopplas";Ascending)

But then i using filter also the data i gallery is visible , but when i go to my edit page , it cant find the recordset , page is white .
Is it the filter making the trouble och the combo of search and filter . 

//SortByColumns(Search(Filter(CRMAktiv;Intresse in //ComboBox2.SelectedItems.Value);TextInput2_1.Text;"Title";"Handledare";"Stad";//"Program";"Notering";"Epost";"Tel";"OData__x00c//5_rskurs_Elev");"aterkopplas";Ascending)

[WarrenBelz · Accepted solution]

Hi @dalacarelia_196 ,

Not sure how all the comment marks fit in, but this is valid code providing your values are valid, although you should add the possibility of the combo box not having a selection. 

SortByColumns(
   Search(
      Filter(
         CRMAktiv;
         (
            IsBlank(ComboBox2.Selected.Value) ||
            Intresse in ComboBox2.SelectedItems.Value
         )
      );
      TextInput2_1.Text;
      "Title";
      "Handledare";
      "Stad";
      "Program";
      "Notering";
      "Epost";"
      "Tel";
      "OData__x00c//5_rskurs_Elev"
   );
   "aterkopplas";
)

 Also if it is a single selection, you only need

(
   IsBlank(ComboBox2.Selected.Value) ||
   Intresse = ComboBox2.Selected.Value
)

What is the Item of your Edit form?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[dalacarelia_196]

Hello there i find my bad code
In Onselect , i reset nex pages form in that gallery 🙂

//;;Set(TjResForm; true );;Set(TjResForm; false )
now its working 🙂