Results 1 to 10 of 10
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Principle of tab forms. (2000)

    Hi,
    I'm hoping that someone can clarify how I should be approaching tab forms.
    I have a database that is normalized as it should be. Normally I would build a Main form with a sub form, the sub form with a sub form and so on.
    However a tabbed form would seem a more approptiate method of dealing with this due to the amount of tables I need.
    Currently I have a main form with a tab form on it. When I enter forms on the tab forms they obviously come up as subforms in relation to the main form. However I need the forms to effectively cascade as they don't all relate to the main form.
    Should I be linking them differently to my normal process?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Principle of tab forms. (2000)

    Say you have subforms Sub1 and Sub2 on the main form. Sub2 should be linked to a field called ID on Sub1. Put a text box txtSub1ID on the main form with control source

    =[Sub1]![ID]

    and use txtSub1ID as Link Master Fields for Sub2. The text box can be hidden (Visible = No).

  3. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Norfolk, England
    Posts
    744
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Principle of tab forms. (2000)

    Thanks, that clarifies things. I did wonder whether this would be something that would have to be done due to all the sub forms being a sub form related to the main form.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Principle of tab forms. (2000)

    If you want my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> worth, tabs are a great if you can implement them in your form design when you have numerous subforms. It keeps the form neat, concise and tidy. Nested subforms can easily get complicated and over engineered, equally too many tabs for data entry can also complicate things but with a good approach and design can make debugging much easier. Take a balanced view of your design.
    Jerry

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Principle of tab forms. (2000)

    Nigel

    If you end up with quite a few tab pages with a lot of data on the subforms it can slow the system down quite a bit when the form is opened. I have found it useful to set the recordsource of the subforms on all tab pages except the first to blank, and then to populate them only when the particular tab page is clicked. This can save quite a lot of network traffic.

    Nick

  6. #6
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Principle of tab forms. (2000)

    Nick,

    Could you add some specifics on how you set the pages to blank, then populate them when they are activated. I have a form with 9 tabs and is loading slow. I think this would be a possible improvement.

    Thank you,
    Carla

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Principle of tab forms. (2000)

    Have a look at Microsoft Access Performance FAQ.

    To speed up forms, go to the link : Microsoft Access Performance - Forms
    Francois

  8. #8
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Principle of tab forms. (2000)

    Francois,

    Thank you very much for the information. I have not seen this before, and it is going to be very helpful for some of the user forms that are getting a little sluggish. Can't wait to get to the office to try this.

    Carla

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Principle of tab forms. (2000)

    Carla

    Did you pick up the information you needed from the links suggested, or do you need any more ?

    Nick

  10. #10
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Principle of tab forms. (2000)

    Nick,

    Links provided a good amount of information to work with. I will be at work to test this tomorrow. I will post back if I have additional questions. Thank you for the followup.

    Carla

Posting Permissions

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