setting a filter on subforms

daroon

Hi does anyone know how to set a filter on a subform ? I wanna push a Button an then a filter should be set on a field in the subform on this Form !

Thanx for helpin me

Greeting

Ronnie

Luc_VanDyck

Therefore you need to create a function in the subform where you can set your filter. You call that function from your main form using CurrForm.NameOfSubform.FORM.NameOfFunction;

daroon

Thank you Luc

great Idea and it Runs <img border="0" title="" alt="[Smile]" src="images/smiles/icon_smile.gif" />

Greetings

Ronnie

Art

Found this item when looking for a solution for a next problem.
This solution works fine, but does not 'refresh' the subform when changing a filter on the main form. Using CURRFORM.UPDATE works fine, except when there are no records in the subform left that match the criteria of the main form. An error message occurs and the window closes. Using the OnTimer function has the same bug.
When not using CURRFORM.UPDATE the error occurs when activating the subform. How to work around this bug?
I tried the main-subform solution, because filter values disappear when deactivating and activating the filterform again. Take a look at form 6000 Dispatch Board. Give in a filter, activate another window inside the Navision session and activate form 6000 again. The filters are still there, but not visible (only when activating the filterfield).