Filter Subform

sarmig

Hi there.

This may seem like a silly and beginner question, but I haven't found the answer anywhere.

I have a form, with a subform in it, and I need to filter a field on the subform (list), based on the value of another field in the main form (card).

For example, my current record in the main form has a field called "type", and its value is 'abc', I want to filter the subform's "type" field with the value 'abc'. Only the lines whose "type" value is 'abc' should appear on the subform.

How do I do it?

Sog

In the properties of the subformbox in the main form you have subformlink.
There you can describe the relation (aka filter) between the main and subform

sarmig

Can't I do it through code? I need to add another condition in which the filter depends on the value of another field.

FDickschat

Just place a "SetFilter" Function in the Subform which you call from the mainform, which sets the filter.

sarmig

I wrote this code on the OnAfterGetRecord trigger of the main form. Is there something missing?

(the form_diario_fusao is a form variable of the subform,)

recDiarioFusao.RESET;
recDiarioFusao.CALCFIELDS(DescMaterial);
recDiarioFusao.SETRANGE(DescMaterial, "Cod. Material");
IF recDiarioFusao.FINDFIRST THEN
MESSAGE('%1', "Cod. Material");
recDiarioFusao.CALCFIELDS(DescMaterial);
  MESSAGE('%1', recDiarioFusao.DescMaterial);
  form_diario_fusao.SETTABLEVIEW(recDiarioFusao);

mohana_cse06

I think you need to create a function in Subform and call it from main form by passing the field value
CurrForm.SalesLines.FORM.Filterlinerecords(mainrec.field);

sarmig

I read that somewhere, and it makes sense, but what would that function do?

mohana_cse06

Function should filter the Line records based on the passed value..

sarmig

Found the solution!

"You need to reference directly to the Subform control and not just another instance of the form.

Give the subform control a name in the properties. Let's say MySubForm.

Then you can use:

CurrForm.MySubForm.FORM.SETTABLEVIEW(recDiarioFusao);

Or via function on the Subform as suggested."

http://dynamicsuser.net/forums/p/45628/ ... spx#230706

Thanks for the help

mohana_cse06

if you modify the value in main form type field from abc to xyz?
is it filtering the subform?

sarmig

Yes and no.

No, because it's not an editable field.
Yes, because it changes when I change the record (and the value is different).

mohana_cse06

sarmig wrote:

because it's not an editable field.

:thumbsup: