Access Forms - Copying

Question

Hi All,

Hoping you can help.

What is the best way to copy an Access form with another name and updated tables.

Brief scenario:

I already have tables and a form set up for data entry called pre-test.  Form has subforms.  Now I need to enter data for post-test.  I copied my tables and renamed them as post-test, added a "2" to all the variables.  Now, what is the best way to copy the forms.  Do I individuall copy the subforms and change the record souce to the new tables, or do I go to the main form and change it all there. I tried both ways. If I change everything in the Parent table, I don't actually have the "child" tables.  If I change the individual "child" table first, then they are not changed when I go back to the "parent" table.  And I have also run into the problem when I first copy the main table, that the original pre-test forms loses its link to the correct table.

so, my question is, what is the best way to copy forms and tables? Or do I have to re-create the forms from scratch,

thanks,

Answer 1

Now I need to enter data for post-test.  I copied my tables and renamed them as post-test, added a "2" to all the variables.  Now, what is the best way to copy the forms. 

Do not duplicate tables but just add field to indicate 'Post-Test'.  Use criteria in query as to whether you want pre-test, test, or post-text data.  

To copy form just open in design and save as a new name.  Edit record source and save.

---

Build a little, test a little.

Answer 2

If the pretest and post-test tables are the same, then you should NOT copy the tables. It is better to just add a field to the main/parent table that indicates the test type. 

TIP: You can have multiple forms edit the same table

If you want to use two forms, I use a hidden test box that has the test type set as the default. In the record source of the main form, you can filter the record the the desired type in the query.

---

Boyd Trimmell aka HiTechCoach HiTechCoach.com Microsoft Access MVP