Reports

[Guest]

I am trying to create a report using design view - When I add a text box and
click on the 3 dots on the properties window so I can add the control source
which works fine -- However When I run the report I am getting the following
error in the text box field "#Name?"

I am trying to use more than one query/table to build his report

Any help on how to fix this problem

Thanks

 

[Duane Hookom]

A report has only one Record Source. A WAG suggests that you are attempting
to set a control source to something like:
=tblEmployees!SomeField
This won't work.

What are you trying to accomplish? What is your control source? Is your
control source a field or expression based on your report's Record Source?

 

[Guest]

My Record source is a field and expression

A report has only one Record Source. A WAG suggests that you are attempting
to set a control source to something like:
=tblEmployees!SomeField
This won't work.

What are you trying to accomplish? What is your control source? Is your
control source a field or expression based on your report's Record Source?

 

[Duane Hookom]

Again, "What are you trying to accomplish? What is your control source? Is
your control source a field or expression based on your report's Record
Source?"

Please read and respond to all questions when someone is attempting to
provide assistance. We ask questions because we need information. Failure to
provide needed information takes extra time and effort. If you don't
understand a question, at least acknowledge the question and ask for
clarification.