Filtering table in subform

StefanWeinreich

Hey all,

i need to filter data shown in a subform.
The subform simply contains telephone-call-data.
In the mainform exists a control where the user can select a certain phonenumber, so only the call-data from this certain number shall be shown in the subform.

That means i have to filter the data in the subform and to update it.
How can i provide this ?

---

thanks in advance
STEFAN

eromein

I don’t know exactly what you mean, but try this.

1.) Name you subform on the mainform. (Properties of subform/Name)

2.) Make a function in the table of the subform in witch you set your filters.
3.) Call that function in a new function in the subform.
4.) Call that function from the mainform.


You can do it like this:

CurrForm.Saleslines.FORM.SetTelFilter();

Saleslines is the name of you subform. (Step 1.)
SetTelFilter is the name of the function on your form. (Step 3)

You can use parameters to make your filtering variable.

Good luck!

Greetz,
Emiel Romein
The Netherlands