Options

Filters on a Form

novusgrnovusgr Member Posts: 6
I have a form
The form is defined as "LookupFormID" of a table
The form property "Save Values" id setted on "yes"
I set some filters on the form and subsequently when i run the form, the filters are active : OK.
BUT WHEN I RUN THE FORM WITH PF5 (the form is automatically called because is the LookupFormID) THE FILTERS ARE NOT ACTIVE.
Somebody can help me to have the filters active also in this case ?
Thanks

Comments

  • Options
    TRSOEgroupTRSOEgroup Member Posts: 37
    novusgr wrote:
    I have a form
    The form is defined as "LookupFormID" of a table
    The form property "Save Values" id setted on "yes"
    I set some filters on the form and subsequently when i run the form, the filters are active : OK.
    BUT WHEN I RUN THE FORM WITH PF5 (the form is automatically called because is the LookupFormID) THE FILTERS ARE NOT ACTIVE.
    Somebody can help me to have the filters active also in this case ?
    Thanks

    can't you set the filters on the link to the lookup form?
  • Options
    neogggneoggg Member Posts: 4
    try defining a record type variable for that table, setting the filters on it, and than calling the form with that variable.
    form.settableview(variable);
    form.run;
  • Options
    kinekine Member Posts: 12,562
    It is because if you do lookup the lookup form takes all filters from calling form... (because you want to list all what you filtered... :-)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.