467,087 Members | 1,259 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,087 developers. It's quick & easy.

Crosstab click opening a report

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
  • viewed: 1312
Share:
3 Replies
>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
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
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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Nathan Bloomfield | last post: by
1 post views Thread by krish_4u_only | last post: by
3 posts views Thread by deejayquai@hotmail.com | last post: by
2 posts views Thread by deejayquai@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.