Finance Form Problem!

[Dreamcatcher]

Bit of a newby i'm afriad and come across problem where i have a form for entering payments (fund adjustments) and want the adjustment value entered to auto adjust the fund value control in the same form.
I.e The fund value is $500, you enter an adjustment of $50 and the the fund value auto changes to $550.
Each consultant has their own fund.

I've attached basic example showing a tblconsultant and tblFundAdjustments table linked via consultantid.
FrmFundAdjustment is used for operator to enter adjustments into 'adjustment-value' and i want the 'Fund Value' control to automatically be updated.

I also want the new fund value to populate FundValue in the tblconsultant table?

Any help would be greatly appreciated.
(Not sure if i'm over complicating issue)

Regards

 

[James Dudden]

Hi,
On the after update of the adjustment field I would do something like this:

If Me!Adjustment_Value <> 0 Then
Me!Value = Me!Value + Me!Adjustment_Value
End If

Regards
JD