changing fields to another table's fields

S

sparky

I have made a form using fields from table#1. I want to use fields of same
name from table#2. Easy way to do this?
 
D

dannis

If you want to use data from table2 instead of table1 in the same form
you might edit a "RowSource" property from "table1" to "table2" in a
properties of your form.

Denis.
 
J

John W. Vinson

I have made a form using fields from table#1. I want to use fields of same
name from table#2. Easy way to do this?
Click to expand...

Change the Recordsource of the form from Table#1 to Table#2.

The need to do this strongly suggests that your tables are not properly
normalized. If you're storing several tables with the same structure, each
with different subsets of "the same" kind of data, consider instead using one
large table with an additional field to define the subsets. Then you can
simply filter the form, or base it on a parameter query selecting just one
subset.

John W. Vinson [MVP]
 
Top