Creating an Event from a report

[David]

Hello,

I am trying to create the equivalent of a click-through like we have in an
Excel Pivot Table, from an Access report.

Does anybody know how to create a OnClick event from a text box or field in
an Access report, or a hyperlink, to allow me to present data gathered from
an underlying query to the user?

Thanks.

 

[Allen Browne]

David, you can do that in Access 2007, if you use the new Report view.

It is not really practical in previous versions, so you best bet would be to
create a form that looks like a report.

 

[David]

Thanks.

I actually started doing that after I posted the question...