Reset subform filter after clicking on next record button on Parrent page on Sales Order

george175

Hello all,

Is there some solution to reset used defined filter from button function on subpage, when I will click on next record button on parent page? If I click on next record button, subpage cant filter on next record lines and lines are empty. I have to click on clear filter first.

I know that there is ctrl+shift+a hotkey on subpage, but have to do this automatically.

Any ideas or suggestions?

archer89

why do you filter the subform?
please describe the whole process, where that is used.

TallyHo

I don't know what you mean by "from button function on subpage" either.

But you could add this global function to the subform:
ResetManualFilters()
RESET;

And in the main form:
Form - OnAfterGetRecord()
CurrForm.SubFormName.FORM.ResetManualFilters;

This will reset all the filters the users set on the records in the sub page when they click next.
But maybe it is better to explain the FILTER indication in the bottom of the document.

george175

TallyHo wrote: »

I don't know what you mean by "from button function on subpage" either.

But you could add this global function to the subform:
ResetManualFilters()
RESET;

And in the main form:
Form - OnAfterGetRecord()
CurrForm.SubFormName.FORM.ResetManualFilters;

This will reset all the filters the users set on the records in the sub page when they click next.
But maybe it is better to explain the FILTER indication in the bottom of the document.

This unfortunately does not work
this is my subpage pageAction filter

RESET;
SETRANGE("Document Type",SalesHeader."Document Type");
SETRANGE("Document No.",SalesHeader."No.");
SETRANGE("Outstanding Quantity")

If I click on next more times or just one time, I have filter on first record still.