Filter in the tablebox

WishmanWishman Member Posts: 36
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??

Comments

  • WishmanWishman Member Posts: 36
    Anybody haven't done it before!!!! :shock:
  • i4tosti4tost Member Posts: 208
    Have you tired CurrForm.Update(FALSE)? Do this after you place a filter SETRANGE.
  • WishmanWishman Member Posts: 36
    I made the setrange in the subform, and when I use currform.update(false), it says form is not open..
  • kinekine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.