Copy and Rename an Access FORM in VBA code 1

[beckwiga]

Can anyone assist with this? I don't know how to code this in VBA. I want to copy an existing Form (which I have the name of) and rename the copy to something else. I want to do this with a Command button in my form. Any comments are appreciated. This is Access 2003. Thanks.

 

[PHV]

Take a look at the DoCmd.CopyObject method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[beckwiga]

Thanks, PHV. I'll take a look.