Listbox filter via Combo box (1 Viewer)

[georg7]

hey guys,
I want to filter my listbox via a Combo box.I tried it with

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

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

 

[arnelgp]

here, try

 

[georg7]

Thank you, it work's perfect! Do you know why I can't select/click the checkboxes in the listbox?

EDIT: nevermind I got it