update field. Is it possible????

[racerrunner]

Hi all,

I've 5 fields in the form.

Field1 outstanding amount

Field2 current amount

Field3 amount to pay

Field4 paid amount

Field5 Amount Pending

Hwever, only field1 is being stored in the table.

my question is how do i update field1?

i.e

outstanding amt: $25
current amt:$37
amt to pay:$62
paid amt:$30
amt pending:$32

the amt pending will overwrite the outstanding amt after i click on next record. Therefore, when i open the form the next time, the outstanding amt should be $32 instead of $25. Does anyone know how to do it? Or is it possible to do this? Thank you.

 

[mhartman]

Hello:
This can be easily done using the Form OnRecordExit event to update the Outstanding Amount Field. SomeThing like below
'
Private Sub Form_RecordExit(Cancel As Integer)
OutstandingAmount = AmountPending
End Sub

This would do it.
Regards
Mark

 

[racerrunner]

Thanks Mark. However, there isnt OnRecordExit event in the form. I'm using access 2k. Is there other event that can achieve the same result? Thank you