VBA Accessi 2007 - creating a calculation field

[Lupson2011]

Hi all



I have two fields, one entitle 'HRSGiven', the other 'ClaimedAmount'.

What I am looking to do is that in the HRSGiven (where the input would be an amount of hours e.g. 2), I want, in the 'after update' event, to perform a calculation in the ClaimedAmount field which multiplies the amount of hours by 25 and places the value in the ClaimedAmount field.

Is there some simple coding I have missed, I have tried various things, but not worked.

Any help?

Marc

[Robeen]

Can you post the code that you have tried?
It sounds to me like what you are trying to do is a very simple thing . . . not sure till I see the code why it is not working for you.

[Missinglinq]

You can either use

Private Sub HRSGiven_AfterUpdate()
  Me.ClaimedAmount = Me.HRSGiven * 25
End Sub

Or, in the Control Source Property for the ClaimedAmount Textbox, use

=[HRSGiven] * 25

Both work, but if you will ever need to manually change the amount in ClaimedAmount, you need to use the first option.

Linq ;0)>