View Full Version : A List of Combo Box Picks to Graph


bobbyba
05-30-2002, 06:43 AM
The user picks choices from a combo box and then these choices appear in a text box separated by comma's.

Following the picks of choices, the user clicks a command button to graph the selected data.

Fields that I want to graph depend upon the choices the user picked in the combo box. Any ideas of how I could use the list of choices that were picked from the combo box to graph respective data?

Fizzio
05-30-2002, 07:10 AM
Probably the best way is to create a temporary table with a single field and on the click of the combo, add each field to the table. Then base the graph on this temporary table. Make sure to clear / Delete the table after each use though.

HTH

David R
05-30-2002, 07:20 AM
Or use a multi-select listbox, and loop through the values to see which ones were selected.
http://www.access-programmers.co.uk/ubb/Forum7/HTML/003528.html

[This message has been edited by David R (edited 05-30-2002).]