about data source???

[jims]

I have an access database developed. I have added a new
table to link to the original developed table. Then I want
to change my original form and add a new bounded text
control field so that I can edit data in the new form.
I need to change the data source for the form in order to
add the new field but if so I will miss my origial data
source. Is that I need to create another query and use
this as the data source. But if so, my original data will
all be lost?? How can I solve the problem??????

[ET Sherman]

Create a new data source for the form using a query. In
the query, link the two tables and inclued the required
fields from each table.

Hope this helps.

>-----Original Message-----
>I have an access database developed. I have added a new
>table to link to the original developed table. Then I

want

>to change my original form and add a new bounded text
>control field so that I can edit data in the new form.
>I need to change the data source for the form in order to
>add the new field but if so I will miss my origial data
>source. Is that I need to create another query and use
>this as the data source. But if so, my original data will
>all be lost?? How can I solve the problem??????
>.
>

[John Vinson]

On Mon, 21 Jul 2003 21:19:21 -0700, "jims" <hylam@csis.hku.hk> wrote:

>I have an access database developed. I have added a new
>table to link to the original developed table. Then I want
>to change my original form and add a new bounded text
>control field so that I can edit data in the new form.

I'm not sure what you mean here. Do you have one form, or two? YOu say
you want to "add a new bounded text control" - that would let you
update a single *field*, but typically a table has multiple fields.

>I need to change the data source for the form in order to
>add the new field but if so I will miss my origial data
>source. Is that I need to create another query and use
>this as the data source. But if so, my original data will
>all be lost?? How can I solve the problem??????

The data resides in your Tables. The queries and Forms are simply
tools to work with that data. Changing the Recordsource property of
your Form to a new Query will not affect the data in the tables.

Typically one would use a Form/Subform arrangement to update data in
two tables; the "one" side table of the one to many relationship would
be the recordsource for the main form, the "many" side table would be
used on the subform, and the linking fields would be used as the
Master/Child Link Fields of the subform control.


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