On a form a text box "GSTRATE" has the following calculation in control source
=(([Purchase Price]*[Purchase Sales Tax])+[Purchase Price])
what code do i write on After Update Event so the result is stored in PurGSTRate field of "purchases" table
On a form a text box "GSTRATE" has the following calculation in control source
=(([Purchase Price]*[Purchase Sales Tax])+[Purchase Price])
what code do i write on After Update Event so the result is stored in PurGSTRate field of "purchases" table
this article helped and have solved to save the calculation in a field of PURCHASES table
used the following
Private Sub Prctxt_AfterUpdate()
PGST = Round(([Purchase Price] * [Purchase Sales Tax]) + [Purchase Price], 4)
End Sub
Private Sub PGST_AfterUpdate()
Call Prctxt_AfterUpdate
End Sub