about data source???

  • Thread starter Thread starter jims
  • Start date Start date
J

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??????
 
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.
 
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.
Click to expand...

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??????
Click to expand...

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