Linked Tables - no new fields?

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

 

[Kevin3NF]

Refresh your table links

Tools>>Database Utilities>>Linked table manager...select the table(s)
inquestion and click OK

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

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

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.