Update records in tabular-form

abab Member Posts: 37
Is it possible depending on a test to activate and deactivate the possibility to modify a record in a tabular-form ? You can do this for the whole form, but I just want to do this for every record that fulfill my test. You can modify some records and can't modify some other records in the same form ! Thanks

Comments

  • tinoruijstinoruijs Member Posts: 1,226
    That's possible.

    In the OnAfterGetCurrRecord:
    CurrForm.EDITABLE(blnField);
    

    or
    CurrForm.EDITABLE(NOT blnField);
    

    or any other condition you may need.

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • abab Member Posts: 37
    I have done this and that's ok! I'am positioned on a record and my currform is disabled. Is it possible to enable my currform when you want to add a new record with F3 or to scroll-down ? Thanks
  • tinoruijstinoruijs Member Posts: 1,226
    ab wrote:
    I have done this and that's ok! I'am positioned on a record and my currform is disabled. Is it possible to enable my currform when you want to add a new record with F3 or to scroll-down ? Thanks

    No. That's not possible. :-k
    I think the solution is to create a function (with F-key) on the form in which you put CurrForm.EDITABLE(TRUE);.

    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • abab Member Posts: 37
    Thanks !!!!
  • kinekine Member Posts: 12,562
    You can try to use "InlineEditing" property of the TableBox control. If you enable this, the form is noneditable by default, but you can use F2 key to start editing any field which is editable... It is good to prevent accidental overwriting of data instead just "seaching" through the table...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.