How do I 'copy' a form design and apply it to a different table?

[jjh]

Hi!
I am making a form that will be composed of two subforms. Each subform will be based on a differrnt table, however the tables are identicle as far as the number of columns. I designed form_1 to be based on table_1. Now, is there a way to copy form_1 (which will be changed to form_2 in the copied version) and redirect it to table_2?

I tried copy and pasting form_1, opened it in design view, looked at the Form properties, specifically: Data-> Record Source, and changed it to table_2, but.....the form didn't pick up table_2 field names, values, etc. I am guessing this is not the way to do this but how does one do this?
Thanks
John

 

[Uncle Gizmo]

It should work if the table is an exact clone of the original. However if you have different names for the fields in the new table, then you will need to go into each control on your new form and pick the particular field that the control should be bound to.

 

[jjh]

It should work if the table is an exact clone of the original. However if you have different names for the fields in the new table, then you will need to go into each control on your new form and pick the particular field that the control should be bound to.

So the form layout will stay the same, cept each control will be mapped to the old table and I will need to click on each control (lable and field both?) to point them to the new table?
Thanks for the help
John

 

[Uncle Gizmo]

>>> I will need to click on each control to point them to the new table? <<<

Yes...



(lable and field both?) No not the labels, you may need to change the caption text though...

 

[Uncle Gizmo]

>>>Record Source, and changed it to table_2, but.....<<<<

BTW for clarity, you still need to change the record source...

 

[jjh]

Thank you! works fine.
-J