Access keeps asking for parameters

[mattalin]

I am creating a report using Design View (New Report>Design View) and I select the table where the object's data comes from. However, I have other tables I would like to use in the report. When I try to add fields from different tables (using the control Source under properties; ex:/ =[Project Expenses]![NPI]) I keep getting a prompt to "Enter Parameter Value." I don't understand why/how to get data from other tables into my report.

 

[Joe4]

You're going about this the wrong way.

First, create a query, linking all the tables you want to use and selecting all the fields from these tables that you will use in your report. Make sure you can view this query without any errors.

Then, create your Report and use this query as your DataSource (possible shortcut: from the Query, select the AutoReport icon, then modify your report).

The point is, you should only have ONE object as your DataSource, either a Table or a Query (not multiple tables).

 

[mattalin]

Thanks.