Hello,
I hope that during a click on the combo box "Conseiller", only those concerning the name in "Dénomination" be selected.
The content of Conseiller :
SELECT t_BANQUE.ID_BanquePK, [Nom] & " " & [Prenom] AS NomPrenom, t_BANQUE.Denomination
FROM t_BANQUE RIGHT JOIN t_Conseiller ON...