Developer Forum

by **BlackSu** » Tue, 22 Jun 2004 07:15:16

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

by **anonymou** » Tue, 22 Jun 2004 07:43:31

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.

in a report to a
of the subreport,

by **MacDermot** » Tue, 22 Jun 2004 10:24:23

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

HTH
- Turtle

subreport,

by **BlackSu** » Tue, 22 Jun 2004 16:36:40

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

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

by **BlackSu** » Tue, 22 Jun 2004 16:43:49

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

by **Roberto da** » Tue, 22 Jun 2004 17:20:19

"BlackSun" < XXXX@XXXXX.COM > ha scritto nel messaggio

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.

--
Roberto

---------------------------------------------
il Sito Comune di it.comp.appl.access:
http://www.yqcomputer.com/
---------------------------------------------