Conditional subreport

T

Terry

John,

Leave both subreports on the main report and in the
section's "on format" event turn the visible property of
the undesired report off.

HTH

Terry
-----Original Message-----
I have a main report with a subreport. The main report
Click to expand...
that contains a certain field for each detail record
(i.e. "Field1"). If Field1 contains a 1, I want the
source of the report to be "rpt1". If it contains a 2, I
want the source of the subreport to be "rpt2". How can I
do this using VBA?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Subreports to create a Main Report 1
Hide subreport and main report record if subreport running sum is zero 9
Subreport doesn't work with a query 0
SynNeed to account for null values in subreports 2
Page numbers don't appear in subreport 1
Viewing a Subreport 0
Subreport Data Missing Inside Main Report 0
Main Report Header is on SubReport 4

Top