report from crosstab query

[mike02]

hey,

I have a report from a cross tab query. I run the productID as column and then group it by Manufacturer, and sort by client

client-Row
Product-Column
MDate-Row
Manufacturer-Row
Quantity-Value

How can i set it up to make it robust. meaning each time i run the query it could have 5 products or 15...

Also, I use product ID.... I want to have it show the text value of the product.

What i have tried to do is this.... make combo boxes for labels, and make it equal certain value and have 15 run across. but this doesnt show anyvalues... any ideas? Thanks.

[mike02]

Ive got the labels working to be robust. now how can i set up the text boxes? this is what is happening. When i select the client, it puts the products ID in hidden values On my form.

txt1
txt2
txt3
txt4
txt5
txt6
and so on.

Now for example if i select John Doe, His products are 2,4,5,6,7 so in the text boxes that are hidden there value will be:

txt1= 2
txt2= 4
txt3= 5
txt4= 6
txt5= 7

so when i click my button, open report, It brings up my report.

The values for labels are:

=[Forms]![frmEditProducts]![txt1] (Label 1)

Now when im stuck on trying to set up the detail section of the report. The product ids are 1-15 but instead of having 15 setup, I want to set it up to take the value from the textbox on the form to be the control source of the text box.. I thought something like this:

=[Forms]![frmEditProducts]![txt1]

But that just makes it = 2 (hence the value)

How can i make it Product 2?

The reason is because txt1 can take on any value from 1-15.