Combo box, criteria selection (1 Viewer)

[Superpat]

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 t_BANQUE.[ID_BanquePK] = t_Conseiller.BanqueFK;

Thank to help

 

[The_Doc_Man]

Add a WHERE clause to the combo box's .RowSource to limit what is shown. I don't open databases that often, so I don't know the names of things. But the idea (with you substituting correct names) would resemble

SELECT t_BANQUE.ID_BanquePK, ....FROM ...  WHERE NomPrenom = Me.Denomination ;

I.e. tie your Denomination column on the main form to the Denomination column of the combo box.

 

[Superpat]

@The_Doc_Man
Thanks to answer, that don't do at all.
I try this, and I clic on the ID 2, it's ok, but after, if I click on another, the fields does not update, see below (1 with 2) :

SELECT t_BANQUE.ID_BanquePK, [Nom] & " " & [Prenom] AS NomPrenom, t_BANQUE.Denomination
FROM t_BANQUE RIGHT JOIN t_Conseiller ON t_BANQUE.[ID_BanquePK] = t_Conseiller.BanqueFK
WHERE (((t_BANQUE.ID_BanquePK)=[ID_BanqueFK]));

 

[bastanu]

Please have a look at the attached updated file, should do what you want. While you are actively selecting a contact in the combo the rest of the records with a different denomination will look blank but they'll get reset when you exit the control. Another alternative is to us a hidden text box to do the actual selection, there are many examples of that in this forum.

 

[Superpat]

Please have a look at the attached updated file, should do what you want. While you are actively selecting a contact in the combo the rest of the records with a different denomination will look blank but they'll get reset when you exit the control. Another alternative is to us a hidden text box to do the actual selection, there are many examples of that in this forum.

Thank you very much for your help and advice, I had no idea how to do it.

 

[bastanu]

You're very welcome, good luck with your project!

 

[Superpat]

Thanks @bastanu