Editing forms with data from multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a relational database that has four main tables (and a number of
small reference tables). The tables are complete, and most of the associated
forms are complete. I created the forms from the tables, not from queries.

I would like to create a form that displays fields from more than one table.
If I use the wizard to create the form from multiple tables, this works
fine. However, I initially used the wizard to create a form that includes
ONLY fields from one particular table. Then I spent a great deal of time
formatting the form. Now I want to add to the form a related field from a
DIFFERENT table (simply to display the associated value), and I cannot for
the life of me get this to work. I've tried everything I know, and I've run
out of options. Of course I could start from scratch and create a new form
with the wizard and then take hours to re-format everything, but I don't want
to do this every time this situation comes up.

When I look at the properties of the fields, there seems to be no indication
regarding from which table the values are coming.

It seems to me that this should be an easy thing to do, but apparently not.
I've tried going through the Access Knowledge base, but no luck.

I have no programming background, but if that’s the only route I can take to
accomplish this, I’ll try it if someone can walk me through it.

Thank you for your help!
 
Hi DiHo,

Create a new query which contains all the fields in the table that are
already in use in the form, and also the fields in the related table(s) that
you would like to add to the form. Save the query, then open the form in
design mode. In the form's property sheet, change the data source from the
table to the saved query. you will be able to add the new controls and your
form will retain it's design.
 
SusanV,

It took me about two minutes to follow your instructions, and it worked
perfectly! I wasted so much time trying to figure this out on my own. This
discussion group is the way to go. Thank you so much!
 
This is a great place to learn - I read a lot more posts and responses than
I know how to answer...

Glad to help any time!
 
Back
Top