Form and tables not connecting

[Guest]

I have a database project that I was trying to make more efficient (I've been
doing the dangerous thing of reading about Database Normalization). I have
one form that was based on the single table I started with. I've now broken
the table into two separate tables. All of the fields from the original
table still work fine.

I tried to re-link the fields in the new table to the corresponding items on
the form. I did this by changing the Control Source of the Text Box to point
to the new field in the new table, but when I try to use the form I just get
an error in the Text Box that looks like it cannot find the data that is
supposed to be displayed.

I really don't want to create the form from scratch so I'm hoping there is a
way to relink the old form to the fiields that moved to the new location in
the new table.

Any suggestions?

 

[Guest]

The form itself has a data source. Have you also changed this to point to
the new table?

--
HTH

Mr B
email if needed to:
draccess at askdoctoraccess dot com

 

[Jeff Boyce]

It sounds like you are saying you have one form that you'd like to use for
data entry in two tables.

A form can be bound to a source, a single table, or a single query. If you
want to show two tables' data on your form, you'll need to use a query to
join the tables together.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I really don't want to create the form from scratch so I'm hoping there is a
way to relink the old form to the fiields that moved to the new location in
the new table.

Any suggestions?

If the two tables are related one-to-many, you should almost surely use a Form
for the fields for the "one" side table, and a Subform for the "many". You can
copy and paste the controls from your current unitary form onto new forms,
though you may need to tweak how they're arranged.

You can base your Form on a Query joining the two tables, but this can be
tricky: you can get apparently duplicate records, and ambiguities about which
table is being updated.

John W. Vinson [MVP]