Thanks for your help but it's still not working. Maybe I'm doing something wrong.
Here is my original recordsource:
SELECT Beneficiaire_Name, Beneficiaire_PropositionNo FROM Beneficiaire WHERE Beneficiaire_PropositionNo = " & DataProposition.Recordset!Proposition_No
First, I guess you must know that i'm using this recordset at design time, on the data control recordsource property, not in code. This recordset gives me the following error: Syntax error in string in query expression 'Beneficiaire_PropositionNo = " & DataProposition.Recordset!Proposition_No'. I tried taking off the concatenation and it says Too Few Parameters, Expected 1.

Thanks again.