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?
 
Top