setting a filter on subforms

daroon
daroon Member Posts: 35
edited 2004-10-14 in Navision Financials
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

Comments

  • Luc_VanDyck
    Luc_VanDyck Member, Moderator, Administrator Posts: 3,633
    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;
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • daroon
    daroon Member Posts: 35
    Thank you Luc

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

    Greetings

    Ronnie
  • Art
    Art Member Posts: 2
    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).

Categories