Crosstab click opening a report

PaulRed via AccessMonster.com

I'd like to click on a control in a crosstab query, say Col 4, Row 3, and
have the On Click event open a report showing the underlying data making up
that summed # in Col 4, Row 3.
Is this a complicated thing to do or relatively easy?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200802/1

Feb 2 '08 #1

Linq Adams via AccessMonster.com

>Query? There aren't events in a query.

I know that, Salad! That's why I was confused when the OP said

"I'd like to click on a control in a crosstab query... and have the On Click
event open a report showing"

and you responded at length, giving code to do so!

--
Message posted via http://www.accessmonster.com

Feb 3 '08 #2

PaulRed via AccessMonster.com

Sorry, folks. In my original post, I meant to say a form based on a crosstab
query.

Linq Adams wrote:

>>Query? There aren't events in a query.

I know that, Salad! That's why I was confused when the OP said

"I'd like to click on a control in a crosstab query... and have the On Click
event open a report showing"

and you responded at length, giving code to do so!

--
Message posted via http://www.accessmonster.com

Feb 3 '08 #3

Linq Adams via AccessMonster.com

Then Salad's advice is the way to go.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200802/1

Feb 3 '08 #4