How to calculate and Update Field via VBA

[rd.prasanna]

Hi All,

I have a unbound text box which calculate the "Earned Value" based on the other fields of the other tables.
My concern is how to do it using VBA coding... and which should get update every time user changes the value.
I tried with change event which is not working... actually i don't know much about Access VBA.

And can anybody suggest me a best tutorial for Access.



kindly help me in this regard.
Thanks in Advance...

[JoeM]

Usually, any field which is a direct calculation of other fields should not be stored as a value, it is just calculated in a query.
Queries are dynamic, so any time one of the values changes, the calculated value would automatically change.
Is there some special reason why it cannot be done this way?

[Missinglinq]

The OnChange event fires every time a character is entered in a Textbox, which is not really appropriate for this kind of thing; the determining Control's AfterUpdate event is normally used, when it's done at the Form-level.

JoeM's suggestion of doing it in a Query is a good one, or you could do it using the Control Source Property of the Control where the determining data is being entered. But you need to explain a little more about the specifics, here, especially the "based on the other fields of the other tables" part. How many 'other fields' in how many 'other tables?' The answers to these questions may determine the best approach in this specific case.

Linq ;0)>