Adding Tables to a form in Access 2000

  • Thread starter Thread starter Bill McAdoo
  • Start date Start date
B

Bill McAdoo

I created several tables and forms for the individual
tables. I also created one additional form that would
include data from all of the tables. Once I created
the "big" form, I realized that I needed to add
additional fields to some of the tables.

Question: How can I now add these new fields into
my "big" form. I don't see a way to add a table or
refresh the contents of the tables selected.

Any help is greatly appreciated.

Thank you!

Bill
 
I'm not quite sure what you are asking. A single Form can only be
based on a single Table _or_ _Query_. To display data from multiple
Tables on a single Form, you need to first create a Query to combine
fields from the Tables in a way that makes sense in terms of their
relationships; then you can base the Form on the Query.

If your "big" form is, in fact, based on a Query (you may have used a
Wizard without knowing exactly what it was doing), then you need to
edit the Query format to show the new fields that you have added to
its constituent Tables. They will then be available in the field list
in the Form's design view for you to add Controls linked to them to
the Form.
 
Back
Top