Select Between (Date) AND In TxtBox

Hello,

I'm trying to make a report query work but with no succes so far. Can anyone please help me?
I've got a multiselect listbox and a txtbox (txtCursisten) where the results from the multiselect listbox appear.
I want to get the results out of a table (tblAbsentie) where I can set a start and end date AND use the people selected in the txtBox. So far I've got a NOT working query, a report based on the query and a button on my form.

The VB code behind the "show report" button is this:

Private Sub cmdAbsentiePerCursistPerPeriode_Click()

On Error GoTo Err_cmdAbsentiePerCursistPerPeriode_Click

Dim db As Database
Dim Q As QueryDef
Dim sql As String



If IsNull("Me.txtCursisten") Or Me.txtCursisten = "" Then
Exit Sub
Else

Set db = currentdb()
Set Q = db.QueryDefs("qryAbsentiePerCursistPerPeriode")
Q.sql = "SELECT tblCursist.Naam, tblAbsentie.Datum, tblAbsentie.Lesuur, tblAbsentie.AantalLesuren, tblAbsentie.Deelkwalificatie, tblAbsentie.Docent, tblAbsentie.Gemotiveerd, tblAbsentie.Reden, tblAbsentie.Status, qryCountLesuren.SumOfAantalLesuren" & _
"FROM (tblCursist INNER JOIN qryCountLesuren ON tblCursist.OVnr=qryCountLesuren.OVnr) INNER JOIN tblAbsentie ON tblCursist.OVnr=tblAbsentie.OVnr" & _
"WHERE (((tblAbsentie.Datum) Between [Voer begindatum in] And [Voer einddatum in]) AND ((tblAbsentie.OVnr) In ("Me!txtCursisten"))); "
Q.Close

DoCmd.OpenReport "rptAbsentiePerCursistPerPeriode", acPreview
End If

On Error GoTo 0
Exit Sub

Exit_cmdAbsentiePerCursistPerPeriode_Click:
Exit Sub

Err_cmdAbsentiePerCursistPerPeriode_Click:
MsgBox "Selecteer klas en cursist(en)."
Resume Exit_cmdAbsentiePerCursistPerPeriode_Click

End Sub

I get a syntax error when pressing the button. Please help...
SeBasTiaan