Filter Subform

sarmig · 2011-09-21

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 · 2011-09-21

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 · 2011-09-21

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 · 2011-09-21

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

sarmig · 2011-09-21

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 · 2011-09-21

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 · 2011-09-21

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

mohana_cse06 · 2011-09-21

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

sarmig · 2011-09-21

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 · 2011-09-22

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

sarmig · 2011-09-22

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 · 2011-09-22

sarmig wrote:

because it's not an editable field.

:thumbsup:

Filter Subform

Comments

Categories