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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top