Adding a control source from a different Query

[Guest]

I have a report called 'Regional Volunteer Lists'. It is generated from a
query called 'Regional Volunteer Lists', though only selects volunteers from
the region selected in the Switchboard form control
[RegionComboforVolunteers].

I have the Region name appear on the Report Header through this control source

=[Forms]![Switchboard]![RegionComboforVolunteers]

Now - I also want to have the Coordinators name appear on the header and
have tried using this syntax as the control source -

=[Regional Volunteer Lists - Coordinator Name]![Firstname] & " " & [Regional
Volunteer Lists - Coordinator Name]![Lastname].

When trying to view the report a popup box appears - 'Enter Parameter Value
- Regional Volunteer Lists - Coordinator Name'.

The query to determine the Coordinators name is DIFFERENT than the
underlying query for the report. Can I not have fields represented from
another query [like in the Forms syntax]?. If not, what are my options to
allow this to occur?

TIA
Sue Compelling

 

[David Lloyd]

Sue:

I don't think you can do this through the query reference. Alternatives
include joining your "Different" query with the report query, or using the
DLookup function to find the value in the "Different" query.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have a report called 'Regional Volunteer Lists'. It is generated from a
query called 'Regional Volunteer Lists', though only selects volunteers from
the region selected in the Switchboard form control
[RegionComboforVolunteers].

I have the Region name appear on the Report Header through this control
source

=[Forms]![Switchboard]![RegionComboforVolunteers]

Now - I also want to have the Coordinators name appear on the header and
have tried using this syntax as the control source -

=[Regional Volunteer Lists - Coordinator Name]![Firstname] & " " & [Regional
Volunteer Lists - Coordinator Name]![Lastname].

When trying to view the report a popup box appears - 'Enter Parameter Value
- Regional Volunteer Lists - Coordinator Name'.

The query to determine the Coordinators name is DIFFERENT than the
underlying query for the report. Can I not have fields represented from
another query [like in the Forms syntax]?. If not, what are my options to
allow this to occur?

TIA
Sue Compelling

 

[Guest]

Thanks David - I'll read up about the DLOOKUP function.