LFRohr
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi LFRohr,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept TimCottee's comment(s) as an answer.
LFRohr, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:
Accept TimCottee's comment(s) as an answer.
LFRohr, if you think your question was not answered at all or if you need help, you can simply post a new comment here. Community Support moderators will follow up.
EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
Comment from expert accepted as answer
Computer101
E-E Moderator
Computer101
E-E Moderator
this might do the trick.
Set Text1.datasource = Dataenvironment1
loop through all controls or one by one.