Add a new field to Table - and then update Form?

[Pat]

Can I do this? Searched a "Access" Bible and all I can come close to this
is linking another (new updated and saved under another name I assume) table
to the Form.

Thank you

Pat....@excellus.com

[Kevin @ 3NF]

If your question is: Can I add a field to a table, an then add a control to
a form bound to that table, then yes, you can do that.

Need help, or just to know if it can be done?

Kevin Hill
President
3NF Consulting
www.3nf-inc.com

"Pat" <pjo...@bicycling.com> wrote in message
news:#rxnGva3...@TK2MSFTNGP12.phx.gbl...

[John Vinson]

On Wed, 26 Feb 2003 10:28:39 -0500, "Pat" <pjo...@bicycling.com>
wrote:

>Can I do this? Searched a "Access" Bible and all I can come close to this
>is linking another (new updated and saved under another name I assume) table
>to the Form.

If you change the structure of a Table, you will probably need to do
the following:

- Open the Form in design view]
- View its Properties
- Select the Recordsource property (on the Data tab)
- Click the ... icon

A Query window will open (accept Access' offer to open it). Add the
newly added field to the Query and close the window, and accept
Access' offer to update the SQL. The new field will now be available
in the list of fields dropdown.

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