New Fields added to Table/Form. Won't appear on form/Print on repo

K

Karen

A Table has been created in Access 2002. Form was created also.

Needed to add additional fields. Went back to original table and added the
new fields to the table. Viewed form again. Information for the new fields
added not showing.

When the report is ran, the new field & it's information, isn't appearing on
the report either.

OR should I just create a new table. But will all the information appear?

What am I missing? I'm very fustrated.
 
G

Guest

Karen,

Double check to make sure the new fields are in the form/report's
Record Source.
 
J

John Vinson

A Table has been created in Access 2002. Form was created also.

Needed to add additional fields. Went back to original table and added the
new fields to the table. Viewed form again. Information for the new fields
added not showing.
Click to expand...

Open the Form (or report) in design view; view its Properties. On the
Data tab select the Recordsource (the first) property, and click the
.... icon. This will open a query design window (accept Access' offer
to use it if you're asked).

Add the new fields to the Query.

They'll now be available in the field list in form/report design view.
New fields will NOT automagically be put onto your form, but you can
use the field list - just drag the fieldname from the list onto the
form where you want to see it.

John W. Vinson[MVP]
 
Top