[flexcoders] filter datagrid using combox and CF

[pal1626]

Hi 
I'm new to flex... I'm developing an application in which I have 
combox as filter for datagrid. I do see the data populated in 
datagrid and combox filter but any selection made in combox won't 
change the datagrid. I'm not sure what I'm missing. ANy help is 
appreciated... 

TEST.mxml code...
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml"; 
layout="absolute" creationComplete="init()">
        
        <mx:Script>
                <![CDATA[
                        
                        import mx.controls.Alert;
                        import mx.collections.ArrayCollection;
                        import mx.rpc.events.ResultEvent;
                        
                        [Bindable]
                        public var acDMA:ArrayCollection;
                        
                        private function init():void{
                                
                                conn.getDMA();
                        
                        }
                        //private function changeEvt
(event:Event):void {
                                //Alert.show(acDMA.getItemAt
(cbDMA.selectedIndex).label);
               // 
OrderGrid.text+=event.currentTarget.selectedItem.label + " " + 
                 //   event.currentTarget.selectedIndex + "\n";
            //}

                        private function select_DMA():void {
                                Alert.show(acDMA.getItemAt
(cbDMA.selectedIndex).label);
                                
                        }
                        
                        private function resultgetDMA
(event:ResultEvent):void{
                                
                                acDMA=ArrayCollection(event.result);
                                
                        }
                        
                        
                ]]>
        </mx:Script>
        <!--Calling CSS Code-->
        
        <!--<mx:Style source="yflexskinGMPW.css"/>-->
        
        <!--Database Server Connection -->
        <mx:RemoteObject id="conn" destination="ColdFusion" 
source="TEST.CFCs.Performance"
        result="OrderGrid.dataProvider = event.result;" 
showBusyCursor="true">
        <mx:method name="getData" result="OrderGrid.dataProvider = 
event.result;" />
        <mx:method name="getDMA" result="resultgetDMA(event)" />
    </mx:RemoteObject>
    
        <mx:DataGrid id="OrderGrid" left="10" right="10" top="50" 
bottom="50" creationComplete="conn.getData();">
                <mx:columns>
                        <mx:DataGridColumn headerText="Brand" 
dataField="Brand"/>
                        <mx:DataGridColumn headerText="Campaign" 
dataField="Campaign"/>
                </mx:columns>
        </mx:DataGrid>
        <mx:ComboBox id="cbDMA" dataProvider="{acDMA}" x="10" y="10" 
width="160" change="select_DMA()"/>
</mx:Application>

CFC code
<cfcomponent output="false">
 <cffunction name="getData" returnType="query" access="remote" 
output="false">
                 <cfset var data="">
                        <cfquery datasource="gmpwMaster" name="data">
                        SELECT Top 1000 Brand, Campaign  
                        FROM dbo.perseus_AdAssignment
                </cfquery>
                
                <cfreturn data>
        </cffunction>
        
        <cffunction name="getDMA" returnType="query" access="remote" 
output="false">
                <cfset var DMA ="">
                <cfquery datasource="gmpwMaster" name="DMA">
                        SELECT DISTINCT Division AS label 
                        FROM dbo.perseus_AdAssignment
                        ORDER BY Division DESC
                </cfquery>
                
                <cfreturn DMA>
        </cffunction>
</cfcomponent>

ANy help is appreciated. I think using change property on wrong 
function.