Linked Tables - no new fields?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cheryl - 19 Jan 2004 14:25 GMT

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.

Reply to this Message

Kevin3NF - 19 Jan 2004 16:04 GMT

Refresh your table links

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

Signature

Kevin Hill
President
3NF Consulting

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

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks for your help.

Reply to this Message

John Vinson - 19 Jan 2004 18:21 GMT

>Hi,
>
[quoted text clipped - 5 lines]
>
>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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message