InputParameters

[BlackSun]

In Access 2003, I need to pass a parameter from a control in a report to a
query that is the record-source of a subreport.

From the manual I should set the InputParameters property of the subreport,
but I don't find it!!!

 

[Guest]

In the query itself, try this criteria against the
appropriate field:

=[Reports]![ReportName]![ControlName]

However, if the subreport is a subreport of the report
you're getting the parameter from, it's better to set
Child and Master fields appropriately.

 

[MacDermott]

I'd suggest using the LinkMasterFields and LinkChildFields properties of the
subreport control.

HTH
- Turtle

 

[BlackSun]

grazie, ma in questo caso non c'è una relazione master-detail, il controllo
del report master è calcolato

 

[BlackSun]

I cannot use master-detail since it's a calculated control, the thing I'm
digging into is that on the online manual it talks about InputParameters as
a property of forms and reports, but.... i don't see it

tx

In the query itself, try this criteria against the
appropriate field:

=[Reports]![ReportName]![ControlName]

However, if the subreport is a subreport of the report
you're getting the parameter from, it's better to set
Child and Master fields appropriately.

-----Original Message-----
In Access 2003, I need to pass a parameter from a control in a report to a
query that is the record-source of a subreport.

From the manual I should set the InputParameters property of the subreport,
but I don't find it!!!


.

 

[Roberto da casa]

grazie, ma in questo caso non c'è una relazione master-detail, il controllo
del report master è calcolato

[CUT]

Nessuno ti vieta di calcolartelo: come Collega campi master fai riferimento
al nome di un controllo calcolato il cui valore te lo puoi calcolare a tuo
piacimento.