Linked Tables - no new fields?

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.
 
J

John Vinson

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.
 
Top