Solved Filter with a sql string

[Etxezarreta]

Hello everyone,
I would like to filter a form with the following string: the parameter is at the right format (string), I ran a few tests with constants, and it works:
May some help me please?
Many thanks in advance!

str_pub_dpt = "SELECT DISTINCT t_CrRdv.Departement" _
            & " FROM (t_ListeDSP INNER JOIN t_DspDepartement ON t_ListeDSP.ID_DSP = t_DspDepartement.Fk_Dsp) INNER JOIN t_CrRdv ON (t_ListeDSP.ID_DSP = t_CrRdv.FK_DSP) AND (t_DspDepartement.Departement = t_CrRdv.Departement)" _
            & " WHERE (((t_ListeDSP.ID_DSP)=[Formulaires]![f_CrRdv]![txt_CritereDsp]))"

Me.Filter = "Departement In ('" & str_pub_dpt & "')"

Me.FilterOn = True

 

[Etxezarreta]

And this string in a query gives me the results I need

 

[theDBguy]

Try using InStr().

 

[Etxezarreta]

Thank you: an error message pops-up:

 

[arnelgp]

remove the single Quote since the expression is a Query:

Me.Filter = "Departement In (" & str_pub_dpt & ")"

 

[Etxezarreta]

remove the single Quote since the expression is a Query:

Me.Filter = "Departement In (" & str_pub_dpt & ")"

I was sure I had already tried, but no: this works!
Many thanks.
Etxe.