Calculate the Value of a Control on a Form.

[Macros]

Okay, you guys have been a great help in the past so here goes a fairly noob question.

I've got a value (Balance) that needs to put into a subform (Finances) after it calculates (Payment-Fee), both of which reside in the subform. If I want it to update for that record immediately, where should I put the expression and could you include an example please. Thanks!!

[Rabbit]

Okay, you guys have been a great help in the past so here goes a fairly noob question.

I've got a value (Balance) that needs to put into a subform (Finances) after it calculates (Payment-Fee), both of which reside in the subform. If I want it to update for that record immediately, where should I put the expression and could you include an example please. Thanks!!

Update the value in the After Update event of Balance.

Private Sub Balance_AfterUpdate()
   Me.[Payment-Fee] = 2 * Me.Balance
End Sub

[NeoPa]

Okay, you guys have been a great help in the past so here goes a fairly noob question.

I've got a value (Balance) that needs to put into a subform (Finances) after it calculates (Payment-Fee), both of which reside in the subform. If I want it to update for that record immediately, where should I put the expression and could you include an example please. Thanks!!

You could just set the Control Source of your control (TextBox) to :

=[Payment]-[Fee]

Without more info in the question there's not much more can be said :/

[NeoPa]

Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR.

PS I've changed this one for you.