Etxezarreta
Member
- Local time
- Today, 19:28
- Joined
- Apr 13, 2020
- Messages
- 175
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!
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!
Code:
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