i have a command button that imports data and creates a chart. it always
creates the chart by rows.
i also have a togglebutton that changes the source to columns and then back
to rows.

the problem is, if the last selection was by columns, and i click the report
button, the chart comes in by rows, but the toggle button is clicked,
nothing happens because it is already in the source by row mode. i need to
click the button twice to reset it.

i need to select the toggle button from the command button code and reset
it's state. that way, every time the report is generated, the toggle button
will be in the original state, sort by column when it's clicked.

can someone hlep me out please?

--


Gary