Update Field

Lamba

Hi,

In a form there are Fields named Qty, Remaining Qty and Issued Qty.

Initially on opening the form the values are:
Qty =100
Issued Qty = 10
so the Remaining Qty = 90

Now close the form and reopen it.
so the value must be updated as

Qty =90
Remaining Qty = 0
Issued Qty = whatever user like to enter.

How this updation on reopen of the form can be done.

Isitar

There is the trigger "Form - OnOpenForm" where you can add your code.
I would suggest you don't use form triggers and use functions on the table instead.

Cheers