Hello
I have a form with some unbound controls on it that allow a user to select various options that a used in a query, a subform with a report in it shows the results of the users options. That bit all works fine and is very snappy and quick.
Under the subform is a OLE MS Chart control that uses another query to summarise the data and display it appropriately.
The problem is, the chart takes an age to load in the first instance. i.e. when the form is opened it renders to screen and then the hour glass comes up, the form (and access) freeze and it's like that for a good minute. Once the chart is loaded, it redraws as quickly as the report subform, and everything else about it is fine. just the initial load is unacceptably long.
For the meantime, I have set the chart to not visible, and the user clicks a toggle button to make it appear (The form loads fine with the OLE Chart not visible, when the toggle is clicked, the same 1 minute-ish hang happens)
I presume the hang is while access loads the OLD MS.CHART object, so my question is... how can I get around the hang? Is there anyway to make the form load in the background (i.e. to not cause access to hang while loading) or to pre-load it when the database is opened?
Help me Accessforums.net, you're my only hope...