Copying of a Form

[Mahendra]

Hello,

I have a primary form. I just want to have the same Primary form twice (The 2nd form will have some design changes only).

When I copy the Primary from and paste it then the copied primary form is unable to open. It resulting in some logical errors to open but when I open the original primary form it is going to open.

What might be the problem in copy pasting of those form.

Could you kindly let meknow how to copy paste a form.

 

[CJ_London]

To copy a form, simply highlight it in the navigation window, right click, selrct copy, then right click again and select paste - ensure your copy form name is not the same as an existing form or the existing form will e overwritten.

The reason the copy form may not be working is if you have a control or query, perhaps in a subform, or some vba which runs when the form is opened which makes use of the name of the form. so if your original form is called 'myForm' and you have a combo box in it with a rowsource which is a query with the following

Select fld1, Fld2 FROM SomeTable WHERE ID = forms!myForm!txtID

Then you new form (called 'myCopy') is still trying to 'look at' myForm.

Depending on your form, try having the original form open before opening the new form and see if the new form opens OK - although in the above scenario the new form will be using values from the orginal form.