I have a table that needs to be duplicated, in whole, not just adding a row, on the next page of a form.
Scenario: The user enters data (employment history) on the first table but requires an additional page with table to complete all work history.
1. I've created a simple table (Table1) wrapped in Subform_EmployHistory which is inside SubformMain_Page2. Theses are the object properties; which I haven't done anything to, yet.
(click on image to see larger version)
2. I've added a "Subform Instance Controls: Add" button object outside the table and its subform
3. Have tried to script the button to allow user to create a new page duplicating the table (not duplicating the data they entered on the first page) table but nothing seems to work.
4. What you see in the next screen clip has not had any script changed or added. Just what shows up when the instance control button is first placed on the page.
What should my script look like? Or, am I using the wrong approach altogether.
Retrieving data ...