Changing source of field information in form?

[Susan]

I designed a form which is set up how I liked it but now I have decided that
I should created a couple of tables instead of one and draw the information
from two places instead of one. Is there a way I can copy the form and then
just change the table source of the fields without changing the layout of
the form?

 

[Jeff Boyce]

Susan

Forms in Access are based on (i.e., "bound to") either tables or queries (or
are "unbound").

Create a query that returns the records you want from the table you want.
Use that query as the source for the new form.

By the way, if the new table is an exact copy of the fields in the old
table, you are "committing spreadsheet" on Access. In a well-normalized
relational database, you wouldn't have need for two "identical" tables.

If that is your situation, post a more complete description for other ideas
from this newsgroup...


--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John Spencer]

Open the form in design view
SELECT File: SaveAs from the menu
Now you can work on this renamed version.

Change the Recordsource of the form. If the new record source has the same
exact field (column) names then you don't need to change any of the controls.

WHY do you want to do this? If you have two data sources that are exactly the
same other than the name of the source you should have only one data source
with an additional field to distinguish whatever the name of the data sources
tell you.

Then use that additional field to filter what is displayed on the form.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Susan]

I am creating two tables. One will have name and address information, the
other will have name and deposit information which can be multiple records
for one individual . I managed to get my first form looking half-way decent
and I hated to start completely over with a brand new form. I just wanted
to copy the form and change the source of the address information to the
address table and leave the other information for the deposit information. I
would then just modify the one table with the deposit information by
deleting the address information. Hope this makes sense. Now I need to read
up on how you tied information from one table to another and use in the
form.