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 HawkinsOP
@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".
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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.