• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

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?
0
LFRohr
Asked:
LFRohr
1 Solution
 
TimCotteeCommented:
You can, you just need to refresh the command object that you have changed the source of. This should maintain the binding, though for certainty I would also refresh any bound component to ensure that it has updated itself to any changes.
0
 
kiprimshotCommented:
Once you change the filter you could try setting the datasources back to your dataenvironment...
this might do the trick.

Set Text1.datasource = Dataenvironment1

loop through all controls or one by one.
0
 
DanRollinsCommented:
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
0
 
Computer101Commented:
Comment from expert accepted as answer

Computer101
E-E Moderator
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now