Applying filter on a Subform

deepblue

Hello!

I need to apply a filter on a field in a subform. The filter is in a text variable and I would to aplly it in the OnOpenForm Trigger in the main form. Can you help me?

Thank you!!!

kriki

Create a function in the subform:

Function SetSomeFilter(ItxtSomeFilter AS text)
SETFILTER("Some Field",ItxtSomeFilter);

You have to give your subform a name in the mainform.
In the "OnOpenForm" of the mainform, you need to put this:

CurrForm."My Subform".FORM.SetSomeFilter(txtSomeFilter);

deepblue

Thank you Kriki!

But it still a little problem. In the subform, I find a record that should not be there. When I click on it, it disappear !

Have you a solution please!! :-k

Thank you!!!

kriki

deepblue wrote:

Thank you Kriki!

But it still a little problem. In the subform, I find a record that should not be there. When I click on it, it disappear !

Have you a solution please!! :-k

Thank you!!!

Change the code in the function of the subform to

Function SetSomeFilter(ItxtSomeFilter AS text)
SETFILTER("Some Field",ItxtSomeFilter);
CurrForm.UPDATE(FALSE);

This refreshes the subform and removes records that are not in the filter.

deepblue

Thank you Kriki!!! =D> \:D/ =D>