InputParameters

  • Thread starter Thread starter BlackSun
  • Start date Start date
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!!!
 
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.
 
I'd suggest using the LinkMasterFields and LinkChildFields properties of the
subreport control.

HTH
- Turtle
 
grazie, ma in questo caso non c'è una relazione master-detail, il controllo
del report master è calcolato
 
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...
 
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.
 
Back
Top