Adding a field to the field list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a table and the a report from that table and then was asked to add
another column/field to the table. Now I don't know how to get that field to
show up on the field list so that I can add it to the report. Can anyone
help.
 
You need to open the report in design view and see what the record source is.

If it is directly from the table just close the report after saving the
table and then open the report in design view and it will be there.

If it is a query then open the query in design view and add it to the grid
as an output field. It will automatically appear in your field list.

If it is not from the table directly or a query then you will need to type
it in the record source statement. Just insert the table name and field name
using bractets with a period between the two and separate it from the other
fields with a comma.
 
The help given for this problem is right, but I didn't understand it until I
resolved the issue myself, and wrote it up like this:

Check that the Form object you need the field list for is not really a
query, and then check if the query is missing that new field (column),
because although the table may have your new field, the query won't have it
and that field won't appear in the Field List for the control.

In my case, I thought the control's Field List was pulling from the Table of
the same name as the Form, but in fact the control was formed from a query
made up of fields from several tables, and it was not querying my newly added
table field because the query didn't know about it.

I added the new field/column to the query, and presto! the field from that
table appeared in the Field List.

How did I finally understand what was wrong? When I selected my control, and
clicked on Field List, the Title Bar said Open Issues. The table I thought I
was listing fields from is called Issues, not Open Issues. So then I went
into my database (a freebie, someone's elses) and looked for something called
Open Issues and found a query by that name. And this query was not pulling
from my field called Resolution in the Issues table. So I added it.
 
Back
Top