Refering between Reports

[Xenocide]

Hi

I have this

A report name Etat2 and a report named Etat3

Etat3 is a subreport in Etat2.

Both reports have their own query and what I'm trying to do is that one of the condition in the query of Etat3 is related to a control (a textbox) in Etat2.

I've tried referring like I do with form

WHERE Maitre=[Reports]![Etat2].[Etat3].Reports!txt1;

But it doesn,t seem to work since it always ask me to enter the value of that string each time I start the reports.

Does somebody know if there's another way to do it?

 

[Rich]

[Reports]![MainReport]![YourField]

 

[Rich]

WHERE (((Arrear.fldDate)<[Reports]![rptReminders]![txtDate]) AND ((Arrear.FldID)=[Reports]![rptReminders]![FldID]) AND etc
works fine for me where a separate page is printed for each customer in the list