hey guys,
I want to filter my listbox via a Combo box.I tried it with
But it doesn't work.
The form is called frm_neueSchulung and the listbox should be filtered via grpName Combo box.
May someone can help
I want to filter my listbox via a Combo box.I tried it with
Code:
Private Sub Kombinationsfeld85_Click()
Me!Liste83.RowSource = "SELECT Abfrage1.ID, Abfrage1.Nachname, Abfrage1.Vorname, Abfrage1.GrpName FROM Abfrage1 ORDER BY Abfrage1.Nachname WHERE Abfrage1.GrpName = '" & Me.Kombinationsfeld85 & "'"""
Me!Liste83.Requery
End Sub
The form is called frm_neueSchulung and the listbox should be filtered via grpName Combo box.
May someone can help