Event descriptions...
in [Reports]
|
Prev: Filter where criteria is contained in text string
Next: 'Freeze' Report Header and Page Header in screen view - possib
From: Jack Leach dymondjack at hot mail dot on 25 Apr 2010 11:42 Thanks Marshall, that'll do. -- Jack Leach www.tristatemachine.com "I haven''t failed, I''ve found ten thousand ways that don''t work." -Thomas Edison (1847-1931) "Marshall Barton" wrote: > Jack Leach <dymondjack at hot mail dot com> wrote: > > >More specifically, I have a report with a subreport, and I want to change the > >SourceObject of the subreport based on a value in the main report... > > > >If Me.fldReleaseType = 1 Then > > Me.ctlsrptReleases.SourceObject = "rptOrders_sKBRls" > >End If > > > Up to at least A2003 (and I doubt it's going to change), you > can only set a source object property in the main report's > Open event. Since that is before any values are available, > I don't think it's possible to do what you asked. > > The usual(?) way to deal with the situation is to add both > subreports and change their visibility as needed. > > -- > Marsh > MVP [MS Access] > . >
From: Marshall Barton on 25 Apr 2010 13:02
Jack Leach <dymondjack at hot mail dot com> wrote: >I found some VBA help on it but it wasn't all that helpful... I'm not that >good with reports to begin with and if I understand correctly, report events >have a lot more usage stipulations and forms do. Looks like it'll good >old-fashioned trial & error I totally agree that help is very thin about report event nuances. Lots and lots of trials and many errors is what I've been doing for years. -- Marsh MVP [MS Access] |