Hot Fox: Re: [Access VBA Central] 1 Form used to open Multiple Tabs

quarta-feira, 23 de fevereiro de 2011

Re: [Access VBA Central] 1 Form used to open Multiple Tabs

use a tab control and place subforms on each

----- Original Message -----
From: "Drowner79" <joefonseca79@yahoo.com>
To: AccessVBACentral@yahoogroups.com
Sent: Sunday, February 20, 2011 5:22:47 AM
Subject: [Access VBA Central] 1 Form used to open Multiple Tabs

1 Form used to open Multiple Tabs

I have a requirement that I have 1 form with it's current design. The form is called frmClient

Is there a way to have buttons 1-5 on top that say btnClient1, btnClient2, btnClient3, btnClient4, btnClient5

When the user clicks on button 1 it opens frmClient in a new tab (tab1) with new or all records?

When the user clicks on button 2 it opens frmClient in a new tab (tab2) with new or all records?

When the user clicks on button 3 it opens frmClient in a new tab (tab3) with new or all records?

etc up to btnClient5

-----

The way i have it working is i made frmClient1 as the master, save as frmClient2, frmClient3 ... up to 5. I have 5 copies of the same form.
When they click the buttons it's relating back to each form. I know this is a MAJOR design flaw but not sure how to resolve.

Please help :)

Thanks in advance!

Joe

[Non-text portions of this message have been removed]