Hi,
First of all, sorry to be 7 years late into this thread, but I have been searching last three days for a solution to my problem

.
I have tried the calcfield procedure shown in this thread. It's great and exactly what I am looking for. Thanks for that.
Before actually testing it on my real database elements, I decided to do a test on a test form and test table inside my database.
To do so, I created a very simple table called TblTest which contain 4 fields: Index (integer auto), FieldA (double), FieldB (double) et FieldC (double)
I created a form that contain these 4 fields with the "wizard".
I created a Module1 in which I pasted the calcfield sub. That Module is linked to the database.
In Calcfield, of course, I changed "Height" and "Base" for "FieldA" and "FieldB". I also changed "Area" for "FieldC".
I affected the calcfield macro to fields FieldA and FieldB on event "Text modification".
I created an entry in the form, I saved it, then I attempt to change either FieldA or FieldB.
With the "basic" debug mode, I can see that the program accesses the macro, but it exits the sub on Handlerror. It does not reach "v1=..." or "v2=...".
It seems that the bug occurs at this line: "Form=..."
Is there something I am doing wrong?
Thanks a lot and sorry again for reigniting a cold thread, but I really need your help guys.