B
BTU_needs_assistance_43
I have a chart in a form whos data is dependant on the selection made in
several combo and check boxes. Using a series of queries I've narrowed and
limited the data to the exact data I want. First I make a selection of WHERE
in the first combo box. The next combo box choices are limited by the first
selection as to WHO. The 3rd and 4th combo define the WHEN with a starting
date and an ending date that depends on WHO was selected. The chart's X-axis
is the date range and the Y-axis is another piece of data i brought in. When
I first start up the program it works perfectly. But after some adjustments
it starts to go screwy. The function I wrote into the date criteria line |||
Between [Combo23] And [Combo25] ||| starts to no longer work. Normally
the chart will adjust its X-axis value to match the range selected. But at
some random point it will quit doing that and leave the X-axis at all values
even though only the points within the selected range are being plotted. Then
at some point the X-axis will change values completely to Jan. 1, 1900. When
I check the graph's datasheet it shows that the column of values for the
X-axis has been switched. My dates are now data in the graph and one of my
rows of data are being used as the X-axis value. If i try to switch it back,
half the time the program crashes and the other half it goes back to
normal... for awhile.
Does anyone have any idea as to what the heck the problem here is?
several combo and check boxes. Using a series of queries I've narrowed and
limited the data to the exact data I want. First I make a selection of WHERE
in the first combo box. The next combo box choices are limited by the first
selection as to WHO. The 3rd and 4th combo define the WHEN with a starting
date and an ending date that depends on WHO was selected. The chart's X-axis
is the date range and the Y-axis is another piece of data i brought in. When
I first start up the program it works perfectly. But after some adjustments
it starts to go screwy. The function I wrote into the date criteria line |||
Between [Combo23] And [Combo25] ||| starts to no longer work. Normally
the chart will adjust its X-axis value to match the range selected. But at
some random point it will quit doing that and leave the X-axis at all values
even though only the points within the selected range are being plotted. Then
at some point the X-axis will change values completely to Jan. 1, 1900. When
I check the graph's datasheet it shows that the column of values for the
X-axis has been switched. My dates are now data in the graph and one of my
rows of data are being used as the X-axis value. If i try to switch it back,
half the time the program crashes and the other half it goes back to
normal... for awhile.
Does anyone have any idea as to what the heck the problem here is?