Report - ControlSource

[guldo76]

Access2k
How does the ControlSource really work? The guide isn't that comprehensive...
I have a report based on a query. In that query there are (also) one field 'code' (number) and, say, three fields 'fieldX' where X is a number in 'code'.
I'd like the report (when opened) to display, in a previously un-associated textbox, the values from 'fieldX', where X varies, as is chosen each time the query is executed.
Hints?
Thanks a lot,
Guldo

P.S.: the query is input-based, and the input needed is just that 'X'.

 

[Memnoch1207]

You will want to create a parameter query (F1 type parameter queries, for more info) to allow the user to input the value of 'X' for the particular field you are wanting to sort by.

 

[guldo76]

I'm afraid I didn't explain that well.
I have a query that displays from 2 tables (join); fields such as: "name", "ps1", "ps2", "number". The very last field has just 2 possible values, 1 and 2, chosen when the query is opened. I already have that.
I now would like to build a report with "name" and "ps"; the textbox "ps" has to be associated to "ps1" if in the query I choose 1 (for "number"), or to "ps2" if I choose 2, since as I open the report the query inputbox appears.
I hope I've explained it better.

Thanks for your help.
Guldo