Speed - changing between forms

[wazza]

Hi

I have a form with two graphs, when i close this form to open another the speed is very slow. the form displays the action 'calculating....'

i believe its because of the graph - the only object with data attached.

The graphs rowsource is updated using vb. The rowsource is intially set to a defined query retrieving 0 records in design view. i have tried to declare the row source as "" but i get an error message. I cannot have a rowsoucre of "", a technique i use for my listboxes etc to improve speed.

if i cannot do this, i wanted to try another option and thats to prevent the 'calculating....' i know in Excel you can halt recalculations - is this possible? so i can close my form without all these requeries or whatever its doing..

** also im using echo etc

cheers

 

[wazza]

just for the record...

setting the forms visible property to false instead of closing enabled me to hide the form very quickly and bypass the time consuming 'calculating......'

forms![name].visible = false