Using ALL in a combo box for a report with a chart

[jw5107]

I have a form. On the form is a combo box. Row source of combo box: SELECT FLEET as A, FLEET FROM FLEETResp UNION select "*" as A,"<ALL>" as B from FLEETResp GROUP BY FLEET ORDER BY FLEET;
Column count set to 2. Column widths set to "0",".4".
On the forms OnLoad event: If Fleet.ListCount > 0 Then
Fleet = Fleet.Column(0, 0)
End If

In the query that is for the chart - for the FleetType field: Like [Forms]![DepartMatDelayrpt]![Fleet]
I also have in the same query a date field: >=[Forms]![DepartMatDelayrpt]![BegDate] And <=[Forms]![DepartMatDelayrpt]![EndDate]

When the report is ran - with ALL selected in the combo box - everything looks fine except for the chart data. The chart data shows the values for ALL. Not just for that Fleet or date range. Since I'm using the "ALL" thing, is that throwin' the date range off thats selected?
Any fixes or examples of how I can use ALL in a combo box for a chart in a report?
Thanks in advance,
jw5107

 

[mp9]

There's quite a good explanation of how to add an ALL option to a combo box and successfully use it to as a constraint at

http://www22.brinkster.com/accessory/forms/007.shtml