By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,750 Members | 977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,750 IT Pros & Developers. It's quick & easy.

Chart static values from list box, is this possible?

P: n/a
I want to chart the values from a list box on my form without having
to go back to the table holding the data, is this possible? I have a
list box that has a user defined criteria, when it is set it needs to
go to the server and populate the row source, there are several
hundred thousand records (SQL Backend) and takes somewhere around a
minute or so to load. So based on the values selected in the list it
drives the data on a chart, which takes another 2 minutes. My idea is
to pull all the data at once that I need to drive the chart and load
it to the listbox in hidden columns and chart that data when selected
instead of going back to the server. Is it possible to take these
values and perform this task, if not can anyone recommend something?

Another question, is there a method to take the values for a list box
create a query object and perform a union all statement?
Feb 7 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.