Selection via a crosstab query?

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

Hi, not sure if this should be here or in the forms group, but what I have
is a main form containing customer info with subform1 that contains a
listing of all the orders for the current customer in the main form and
subform2 that contains order details for the currently selected order in
subform1. There is also a third subform which contains a 'size x color'
crosstab query showing all current orders with each size on a row and each
color in a column.

What I want to do is to use the crosstab as a filter criteria for the entire
form - click on a cell in the crosstab and use the values in the row and
column headers to filter for only the customers, orders, and order details
matching those values. Can anyone here tell me how to read the row and
column 'header' or 'label' values referenced by the currently selected cell
in a crosstab?
 
Hi,


In a form? you click in a control, not in a field, that means you have a
control name (property). For the line, retrieve the values of the GROUP used
for your crosstab.


" ... WHERE group1=" & Me.group1 & " AND pivotField=""" &
control.Name & """"



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top