Linked Tables - no new fields?

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Hi,

This is probably pretty easy. I have a backend and a
front end to an Access 97 db. I recently added a few new
fields to the tables in the backend. I now want to add
them to my form but, when I try, the fields I have added
are not available in the Control Source list.

Thanks for your help.
 
Hi,

This is probably pretty easy. I have a backend and a
front end to an Access 97 db. I recently added a few new
fields to the tables in the backend. I now want to add
them to my form but, when I try, the fields I have added
are not available in the Control Source list.

Thanks for your help.
Click to expand...

If relinking the backend tables as suggested doesn't help, open the
Form in design view and view its Properties. Select the Recordsource
property (first on the Data tab) and click the ... icon by it. Access
will open a Query design grid; add the new fields and close the grid
window. Accept Access' offer to save the SQL and your new fields
should be available.
 
Back
Top