Cloning many form objects

[martbarr]

Just tried to clone one of my forms which has loads of objects and found that the form clones ok but the objects don't.
Is there a way to clone the form AND it's objects?
I don't fancy cloning loads of objects individually because we will need to do this a good few times as we develop.

Thanks as always
Martin

[martbarr]

I expect that I can select the objects using a query into a temp table and then amend the formID and regenerate a PrimKey.
And then import back to object table?

[admin]

Martin,

You are correct but you'll also need any objects on any Subforms on that Form.

Steven

[martbarr]

thank you Steven

I've just written a small python script to do this - saved me a bit of time !
But I guess most of us won't want an exact clone - but better to delete objects off a form than add them on individually.
It might be handy to have an index page button which did an entire form clone (just a thought)
(or a page of advanced utilities that we might use "sometimes")

thanks
Martin

[admin]

Martin,

If you had written it in PHP you could have shared it with us as a Activity Procedure!

Steven