Hello everybody
I have two cmb and I want the ComboBox1 to be filtered in base on what is selected in ComboBox2. This works fine:
ComboBox1.Items = Filter(testProjekt_Lokal;ComboBox2.Selected.Kunde_ID=KundeID.Value)
But, if I activate ComboBox1 Search function it doesn't work anymore. I could only write in the ComboBox but no dropdown is offered.
I tried:
ComboBox1.OnSelect = If(IsEmpty(ComboBox1.SearchText);Filter(testProjekt_Lokal;ComboBox2.Selected.Kunde_ID=KundeID.Value))
ComboBox1.OnSelect = If(ComboBox1.SearchText="";Filter(testProjekt_Lokal;ComboBox2.Selected.Kunde_ID=KundeID.Value))
No results.
Any Ideas?