I would like to thanks all off you for replying but I made the select working  by making a small change.

Old not working code:

WHERE (((tbl_Mots_clés.Explication_code_interne) = 'dbcMotsClé.Text'))

new code

WHERE (((tbl_Mots_clés.Explication_code_interne)...