InputParameters

B

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!!!
 
G

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.
 
M

MacDermott

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

HTH
- Turtle
 
B

BlackSun

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

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!!!


.
Click to expand...
Click to expand...
 
R

Roberto da casa

BlackSun said:
grazie, ma in questo caso non c'è una relazione master-detail, il controllo
del report master è calcolato
Click to expand...
[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.
 
Top