Filtering Recordsets Bound to a Form Using the Data Environment Tool
My form uses no data control but instead binds the controls through the command object created in the Data Environment. Using one or more "sort by" combo box values off the form I would like to filter the underlying recordset the form is bound to. Can I change the command text for the current instance of the command object and have all data binding remain in tact?..or another aproach? What is the smart way to accomplish this?