Field List does not display all fields in a table

J

JudyK

I'm fairly new at this, so hope this isn't a dumb question. I created a form
with just a couple of fields on it and now I want to add additional fields,
but when I click the Field List to select the desired fields, there is only 1
field shown. Why can't I see the other fields? Do I have a property set up
wrong or something. Thanks for your help!
 
N

Nona

Take a look at your query. Are any of the boxes unchecked? If they are
unchecked, they will not be visible or available.
 
J

John W. Vinson

I'm fairly new at this, so hope this isn't a dumb question. I created a form
with just a couple of fields on it and now I want to add additional fields,
but when I click the Field List to select the desired fields, there is only 1
field shown. Why can't I see the other fields? Do I have a property set up
wrong or something. Thanks for your help!
Click to expand...

Open the Form in design view; view its Properties (rightclick the little box
at the upper left intersection of the rulers and select Properties).

On the Data tab the first row is the form's Recordsource. Click the ... icon
by it to open a query design grid on the query from which the report gets its
data (Access created this query for you automatically).

Add your new fields to the query grid, close it, accept Access' offer to
update the SQL and you'll have your new fields.
 
Top