Creating an Event from a report

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.
--
David

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" wrote in message
...
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.
--
David

Thanks.

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


"Allen Browne" wrote:

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"David" wrote in message
...
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.
--
David