Computer Learning Zone CLZ Access Excel Word Windows

There are wonders enough out there without our inventing any.

-Carl Sagan
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Visitor Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Duplicate a Form
Kellie Hawkins 

3 years ago
I created a form and need to duplicate the form with the same layout within the same database.  I don't want additional records, I need an entirely separate form - but identical.  I am creating buttons on a main switchboard to go to each company individually - that's why I want the same form but not in the same record.  Is this possible?  I hope I'm making sense.
Scott Axton  @Reply  
        
3 years ago
Quite literally copy and paste it.  Click the form you want to make a copy of and press Ctrl-C.  Then paste it using Ctrl-V.
Rename the form to whatever you want then change the Record Source in the properties of the form.

That being said - I'm not sure why you would want to do that.  There are much better ways to handle working with your data.  I don't know your experience level so I really can't advise you well on what to watch.
Kellie Hawkins OP  @Reply  

3 years ago
I need the same form multiple times but not in a record.  Formatting a form the way I want it to look is very time consuming and I don't want to have to do it over and over again.  I am building a switchboard to categorize my businesses.  When I copy and paste a form, the data changes.  I need the forms to be independent of each other.  My experience level is moderate.  It has been a long time since I have used Access.
Scott Axton  @Reply  
        
3 years ago
Kellie -
What you are describing is a lot of work.  You really don't want to have to add a new form each time you add a new client.
then you have to make a new button to open that one.  Copy a form. Make the changes for that business. etc.

If you only have 2 or 3 not a huge deal but what happens when you have  30 or 300 or even 3000?  Now it becomes a nightmare to maintain.
Then comes the scenario where you decide you need to add in a different piece of data that you want to collect.  I wouldn't want to do that for 3 forms let alone 3000 (or more).

The better way is to create a list form for all of your customers (businesses) and have a button to open that specific customer using a single form.  Much easier to maintain and navigate around to different people.

Go watch the Blank Template video.  Richard shows how to pick a customer and open a single form to the specific customer.
When you get some time, also go watch the Access Beginner 1 video.  I know it is longer but you don't have to watch it all in one sitting. Keep in mind too that it is also FREE.  
The great thing about the videos are you can watch them over and over until you "get it".
Scott Axton  @Reply  
        
3 years ago
Alex or Richard  Would you please combine with: Duplicate a Form
Kevin Yip  @Reply  
     
3 years ago
Hi Kellie, do you want to open the same form twice (or more) and show them simultaneously on the screen?  There are ways to show multiple "instances" of a form without creating additional separate forms.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Visitor Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/21/2026 2:50:08 PM. PLT: 0s