on current in report?

[bbdata]

what would be an equivalent of OnCurrent event/Forms , in detail
section of the Report?
i have a subreport with just one (visible)field, bounded to a query.
subreport is in detail section of main report. i want to display all
the records in the query if the value of field X in main report is 1,
and just one record from the query ( with an invisible field in
sbReport set to 2), in any other case.
can i change recordsource for subReport for every record in Main
Report?

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The equivalent to OnCurrent event is the section's Print and Format
events.

I don't believe you can change the Recordsource of a subreport while the
report is running. You can link the subreport to the main report by the
Link Child/Master Fields properties. Read the Access Help article
"About subreports" for more info. Help Contents hierarchy is (Acc
2002):

Reports and Report Snapshots
Advanced Reports
Subreports
About subreports

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkHH2YechKqOuFEgEQLwygCgjYx5SQTvAojAwWMkl4mW8y 6dv8gAoNO5
t4aAof7T+Z+J1NaYCEDidzYG
=yAHW
-----END PGP SIGNATURE-----
bbdata wrote:

what would be an equivalent of OnCurrent event/Forms , in detail
section of the Report?
i have a subreport with just one (visible)field, bounded to a query.
subreport is in detail section of main report. i want to display all
the records in the query if the value of field X in main report is 1,
and just one record from the query ( with an invisible field in
sbReport set to 2), in any other case.
can i change recordsource for subReport for every record in Main
Report?

[lesperancer]

but you can have 2 subreports linked to your report and make one or the
other visible

[bbdata]

le*********@natpro.com wrote in message news:<11**********************@l41g2000cwc.googleg roups.com>...

but you can have 2 subreports linked to your report and make one or the
other visible

ok im trying that right now and its not working well.
it is switching to not visible, but for ALL records.

is there any way you can manipulate ANY property of the control( field
)in detail section of the subreport, based on the value of any other
control in that same section in the subreport, or in the main report?

description: i have report which should list all active deals. one of
the fields is VendorName. deal can have multiple vendorNames, so i'm
usig subform to print all of them.
problem is, some of the deals have a Contract assigned to only ONE of
the vendors. in that case, i dont want to print all of the listed
vendors, just that one with the Contract assigned.

so theres another subreport, which pulls out just vendors with
contracts.

what was i doing, i was checking the value of contract flag in
subreport for
vendors with contracts, and if its flagged, i set the other subreport
-all vendors- , to not visible. checking in detail_format event of
subform.

that sets subreport to not visible in ALL of the records, regardless
of contract flag, if any of the deals has a vendor with a contract.

same thing if i set just one field on subreport to not visible.

any workaround?