Trapping a user's selection of Crosstab Results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Strange request...

I have a subform that has as its SourceObject a crosstab query..

When the form is opened and the user sees the results of the crosstab query in boxes (intersection of columns and rows), they want to be able to select a specific box and then have the code trap the action and be able to populate other list boxes on the form with the data that was in that particulat box. How can I trap the event of selecting data from a crosstab query. Is there another object that I should be using instead of just a subform

Is this possible

Thank
 
Dear Devlpr:

Not sure how to pronounce that name.

I take it your crosstab is the RecordSource for a subform. So, when
the user navigates that subform, whether single or continuous, the
Current Event will fire. Put some code in the Current Event to
perform the act of changing the RowSource of your list boxes.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Thanks for the quick response, but the only event that I can get to fire is 'On Enter' of the subform, which only fires the first time the subform is entered. Therefore, since the crosstab query returns multiple rows and columns and produces a grid-like structure with many boxes, once they start moving around to different boxes, I can no longer trap their movements

Does that make sense? Should I be using something else other than a subform to display the results of the crosstab query if I also want to allow them to select the resulting values?
 
Dear Devlpr:

I have never seen a case of the Current Event not working. If this is
really the case, you have a major malfunction. Is there any
possibility you aren't looking at it correctly? Are you looking at
the properites of the subform and selecting a current event there?
Please go to the code for this current event and put in one line of
code:

Stop

Better than a breakpoint. Let's see if we can get the Current Event
code working.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top