Results 1 to 5 of 5
  1. #1
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408

    Speed Up form opening

    hi
    i have a form that i built in a long time adding stuff and now it's and hideous bunch of controls. It is slow on opening, probably cause i have a tab control with 4-5 subforms, it's not so long but it takes more than 10 seconds

    i want to rebuilt the form, what's your suggestion to make it more rapid on opening? i think the main problem are the subforms, maybe i should populate them when i select the specific tab? (i know that i have to use the code "tabcontrol.value_change()")

    do you have any suggestion?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Do NOT put in 5 subforms.
    instead, put in 1 subForm and a TAB control.
    You'd have 5 tabs and when the user clicks another tab,you swap out the subForm source.

  3. #3
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    thnks,
    you mean to put the subform outside the pages of tab control right?
    the problem is that those subforms have very different datas, so i can't figure it out how to switch the source

  4. #4
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    As per your original suggestion, Only load them when you select the tab.

    Set the source object to ""
    On the tab change event set it to the subform name.

    Personally, I never unload them once loaded on the active form unless they have a serious effect on the form operation, and it speeds things up if they are already loaded once, and switched between frequently.
    Last edited by Minty; 01-22-2021 at 09:18 AM.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    408
    thanks, then i'll work that way

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Speed
    By Ekhart in forum Access
    Replies: 1
    Last Post: 09-16-2016, 06:54 PM
  2. Need to Speed up Form on Opening, Add Filter?
    By Jlacey91 in forum Access
    Replies: 2
    Last Post: 12-16-2015, 08:29 AM
  3. Form load speed
    By FJM in forum Access
    Replies: 2
    Last Post: 11-24-2015, 10:42 AM
  4. Replies: 5
    Last Post: 01-24-2015, 12:59 AM
  5. Replies: 1
    Last Post: 01-03-2013, 11:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums