Filter in the tablebox

Wishman

Hi,

I searched the forum but I couldn't find a solution. My problem is,
I have 3 fields(one is option, the others are code), and a tablebox. The three fields can't be flowfield because they are keys, in the table. I want to search the header archieve file and get the lines of it.(Sales Header Archive-Sales Line Archive) I wrote a function in the line form, I get the record count when the function returns, after the setrange. But the records don't come to the tablebox.

In which trigger, and what, I have to write my code? I tried onformat trigger,
CurrForm.SalesLineArch.FORM.UPDATECONTROLS;
but it didn't work..

Anybody has an idea??

Wishman

Anybody haven't done it before!!!! :shock:

i4tost

Have you tired CurrForm.Update(FALSE)? Do this after you place a filter SETRANGE.

Wishman

I made the setrange in the subform, and when I use currform.update(false), it says form is not open..

kine

May be that problem is that you have link in master form on subform component and in sub-form you want to change this filter... but these filters are AND...

if you want update controls you cannot do it in OnInit but in OnOpen (but in onopen is Updatecontrols irrelevant, because nothing is drawed) or later...