By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,504 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Crosstab click opening a report

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
>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

P: n/a
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

P: n/a
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.