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.
What I did is had a Sub form on the page had the Buttom a long top
Private Sub section2_Click()
Me.[SHOW_SCREEN].SourceObject = "section 2"
Me.[SHOW_SCREEN].Visible = True
last_screen = 2
The above code would change the Subform [SHOW_SCREEN] to the right screen
the Call Editit Sub did a trick It read all object on the screen and depending What I put into the Tag it would show/hide that feild
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.