Form with a chart opened on top of a modal form

I have a modal form where I set criteria for the creation of a chart. The
chart is located on a second form and when the user clicks the "Create Chart"
button on the first form, the second form is opened which displays the chart.
This second form is opened in modal and popup modes (I get the same results
if the second form is opened as popup only).

Everything works pretty well, except when I try to get the datasheet for the
chart to show. Double-clicking on the chart to bring up the datasheet causes
the system to hang. I can see part of the datasheet behind the chart, but
the entire app hangs. The only way out is a to bring up the Windows Task
Manager and shutdown the app that way.

Does anyone have any ideas on what I might do. If there is no solution, I
guess I could close the first modal form and then open the chart form in
normal mode. But I would prefer not to do this, because the user might want
to go back to the first form, change one item and then create the chart again.
If I have to close the first modal form, then they will have to reenter in
all of the criteria which will be a pain.

Thanks in advance for any help.

--
Message posted via http://www.accessmonster.com