Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2011
    Posts
    1

    Question Unanswered: 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

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 15
    You can open several independent instances of the same form. See: Microsoft Access tips: Managing Multiple Instances of a Form
    Have a nice day!

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,468
    Provided Answers: 10
    What I did is had a Sub form on the page had the Buttom a long top

    Code:
    Private Sub section2_Click()
    Me.[SHOW_SCREEN].SourceObject = "section 2"
    Me.[SHOW_SCREEN].Visible = True
    last_screen = 2
    Call EDITIT
    End Sub
    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

    StePhan McKillen
    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-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •