Reusing forms

[Rebekah]

hi,
I am trying to create a template form to be used for data entry on a few similar forms (a variety of similar data sets). the form template i've created includes a series of subforms. I am not at all sure how to reuse the form - but i don't want to have to redo all the layout stuff again.

is there an easy way to do this?

thanks.
rebekah

 

[Robert Dunstan]

You can copy and paste forms in the database window. Just highlight the form you wish to copy, click the copy button then click the paste and then enter a different name for the new form.

However when you do this the new form will inherit all the controls, layout, code and underlying record source from the original. So you will need to check any code and change the underlying record source as necessary.

hope this helps
Rob

 

[accesswatch]

You can use multiple instances of a form. When you do this can make permanent changes to the master form, changes to the 'cloned' forms must be made in code and are temporary (for the lfe of the clone). Any changes to the clone will not affect the Master form.
One of the issues to look out for is that the 'clones' will have the same name as the Master. 'The Access 97 Developer's Handbook' (SYBEX) suggests that you assign a different CAPTION to each clone in code and use this to identify your 'cloned' form in code.

The following KB Articles should get you started

Access 2000
How to Open Multiple Instances of a Form http://support.microsoft.com/support/kb/articles/Q210/2/48.asp

Access 95 and 97
How to Open Multiple Instances of a Form http://support.microsoft.com/support/kb/articles/Q135/3/69.asp

Hope this helps
Trevor from www.accesswatch.co.uk