how to open report from a report using hyperlink

[bronson_mech]

I Need to open a report from another report ie.) i've 2 reports 1) overview Cost 2) breakdown Cost
If i Click on Overview Cost ID # it Should Display Breakdown Cost For that Particular ID #............

Pls Somebody Advice Me to Fix This.........

[rpeare]

you're talking about drilling down, I haven't done it myself but here's an example:

http://technet.microsoft.com/en-us/l...sql.90%29.aspx

[RuralGuy]

I'm thinking the Access Report may not support such an action.

[June7]

Report in ReportView, not PrintPreview, code could open another report object filtered to the ID.

Use textbox Click event:

DoCmd.OpenReport "reportname", , , "ID=" & Me.ID