Q: Chart in form on demand only

J

Jim

I have this chart on a form. I'm trying to get this chart to render only if
the user chooses to do so. This because of that the chart is quite complex
and takes some time to render.
I know that I probably should put it on a report and call that report from
the form but for various reasons I need the chart on this form.
In a table bound to this form I have a Yes/No field and then from a checkbox
the user should get to choose if the form is rendered or not, for example if
the user has an old computer then he/she would want to turn off the chart
thus getting the form to load faster.
How do I make this happen? If I only set the chart visible or not then it
gets rendered anyway not speeding up the form even if it's chosen not to
show. Is there a way preventing the chart from loading/rendering in some
way? I tried messing with the charts recordsource with IIf and more but
without getting anywhere.
 
Top