Prompt Pops up For new field in report

[djd011]

Hi again everybody,

I am updating a report by adding a field to it that is tied to a text field
on a table. I have two problems that are occuring.
1. When I run the report a prompt pops up that is labeled "Enter Parameter
Value." If I leave the box blank the Report Runs, but I run into the next
problem.
2. The Test Records I placed in that a few places just to make sure the
report was pulling the correct data is not appearing in the report.
I am not sure why either of these two problems are happening but I would
appreciate any help with this.

Thank you!

 

[KARL DEWEY]

When you added the new field did you add it to the form Record Source?
The record source for a form may be a query or directly from a table using a
select statement in the form.

 

[djd011]

How do I find the Record Source, and what will I have to do to add it?

 

[KARL DEWEY]

Open the report in design view, click on menu VIEW - Properties. Record
Source is the top item in the All tab. If the record source is the name of a
query then you need to add the field in the query.
If it is from a table using a select statement then you need to add the
field in the SQL statement - like this ---
Old statement -
SELECT NGCID, CALENDAR, WEEKDAY, NAME FROM Table3 WHERE NGCID<22;
Edited statement -
SELECT New_Field, NGCID, CALENDAR, WEEKDAY, NAME FROM Table3 WHERE NGCID<22;