new control source to a report- How?

[benzo1]

I have an access report. It is generated from several control sources from a single table.

I want to add another control source from another table. But I can't find the option to do this.

Can anyone suggest a solution to this very basic problem?

Thanks in advance.

Tanya.

 

[ssecca]

I think what you are really asking for is how to modify the record source of a report. Once a record source is modified it will display all the controlsources it has.

To do this goto design mode on the report, right click and select the properties for the report as a whole. This is done by right clicking the small box in the uooer left corner of the report, the one with the small black square in it. Go to ALL, RecordSource, then click on the elispe the three dots to the right. Thsi will open the QBE allowing you to modify the recordsource as needed.

Goos Luck
ssecca