Duplicate Form

K

Kanga

Hi,
I have two exact same tables. For one of them I manually designed a form. Is
there a way that I can create the same form for the second table without
redoing everything manually?
Thanks,
Kanga
 
O

Ofer

Copy (Ctrl+C), Paste(Ctrl+V) to a new name, and then go to the form
properties and change the record source of the form to the new table.
 
A

Al Camp

I'm not sure why you would want to do that but...

Yes, you can just copy your form with a new name, and make the RecordSource
your 2nd table.
Open form1, and use SaveAs to save it to another name. Now you have two
duplicate forms. Just use table2 as the Recordsource of your 2nd form.

As long as you are "absolutely" sure the tables are identical... they should
both work.

Or, you can use the same form, and programatically alternate the
RecordSource from table1 to table2.
hth
Al Camp
 
T

tina

if you have two identical tables in the same database, there's a strong
possibility that your table design is not normalized. if you're not familiar
with normalization guidelines, recommend you read up on the subject and then
review your tables/relationships design.

hth
 
Top