Pretty simple cfm giving me lots of problems

Okay. Thanks for the follow-up. Here's how I do these sorts of things in Flex applications with a CF back-end.

In Flex, create your form:

<mx:Form id="myform">
     <mx:FormItem label="The Field">
          <mx:TextInput id="thefield" />
     </mx:FormItem>
     <mx:FormItem label="The Field">
          <mx:Button id="thebtn" click="doIt(event)" />
     </mx:FormItem>
</mx:Form>

Setup a RemoteObject. The destination, ColdFusion, should be enabled in any CF8 or CF9 install, if not Google on setting up the services-config.xml and remoting-config.xml files in Flex. The source is the dot-notated path to the CFC, starting at the web root (you can enable ColdFusion mappings to be used instead of this full path but that requires editing the remoting-config.xml file). The mx:method tag or tags are used to list the CFC functions that get invoked and the appropriate event handlers after the CFC function is executed.

<mx:RemoteObject id="roMyCFC" destination="ColdFusion" source="path.to.cfc.on.server.CFC_NAME_NO_EXTENSION">
     <mx:method name="doAction" fault="serverFault(event)" result="yeah(event)" />
</mx:RemoteObject>

Next, for this example, you need to set up three functions: (1) the doIt method to handle the form submission (invoked by the button's click handler); (2) the serverFault method which handles errors sent back by ColdFusion, and (3) the yeah method for when the CFC method works properly and returns a result.

private function doIt(event:MouseEvent=null):void{
     // this example only submits a single parameter but you just add more and more as needed
     roMyCFC.doAction(
          this.thefield.text
     );
}
private function serverFault(event:FaultEvent):void{
     mx.controls.Alert.show(mx.utils.ObjectUtil.toString(event.fault));
}
private function yeah(event:ResultEvent):void{
     mx.controls.Alert.show( event.result as String );
}

Finally, you need the CFC and all methods to be used by Flex must have their access set to remote. Because of the ActionScript/Flex 'yeah' method above is expecting a string to be returned from ColdFusion, we set the returntype attribute to string ... and return a string, of course! 

<cfcomponent>
     <cffunction name="doAction" output="false" access="remote" returntype="string">
          <cfargument name="thefield" required="true" />
          <cfscript>
               // do some stuff (insert into db, etc.)
               result = "Yeah! Everything was saved";
          </cfscript>
          <cfreturn result />
     </cffunction>
</cfcomponent>

I know this is an overly simplified example, but I hope it shows you how you can better integrate Flex and ColdFusion applications (better than HTTPService and WebService calls, that is!). One final note: all the Flex and ActionScript code I have above would go into the same MXML file.

Sorry about that, as it sits it gives me a       [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 5. error.

I tried to simplify the query and just query Subject and Remarks and i got the following error:

The entity name must immediately follow the '&' in the entity reference.