Open a form in hidden mode at startup

[Terpsfan]

I have a form that I want to load at startup but want to keep hidden until the user needs to make it visible. The form normally takes about 15 seconds to open, because this has about 20 tabs and 800 fields. I figured if I loaded the form at startup in hidden mode, then made it visible when needed, it would make the form appear to open quicker. Does anyone have any ideas on this? Thanks

 

[WildHare]

WOW...800 fields? That seems like an awful lot for one recordsource.

Opening the form hidden will take no less time than opening it normally, since the data needed to populate the controls will still need to be gathered. If you have several complex queries that produce your recordset, there's no quick way to open it.

It would also seem to me that a 15-second wait while nothing appears to be happening might be disconcerting to the user.

Are you sure you design is correct? 800 fields on one form?....



Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm

 

[jbehrne]

I think that if you open to a some sort of switch board and run this code on startup it may work.


DoCmd.Open FormName
Forms!FormName.Visible = False

Then when you need to 'open' the form do this:
Forms!FormName.Visible = True

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations

 

[Terpsfan]

What I was trying to do is run this during the time that my splash screen shows for 7 seconds. Now, the reason I have 800 fields is because I'm running a subform for each tab. It's helpful to be able to tab back and forth between different tabs to do the review and have it all visible. So there aren't 800 fields tied to one record source, it's actually about 20 different record sources. I've determined that the problem lies more with Access. The way around it seems to be to go the unbound form route, or to make the tabbed subforms only visible when needed.

 

[jbehrne]

I'm curious, are you using alot of comboboxes/continuous forms in the form? I've found that if there is a large amount of data being pulled into the comboboxes/continuous forms then the main form loads/runs really slow... Maybe that's your problem... Anway, that's just my 2 cents worth.
jbehrne

If at first you don't succeed, call in an airstrike. - Murphy's Laws of Combat Operations