Calculation on a form

M

Martin

I have a form/subform combination. A control on the main form uses a custom
function to calculate a value using fields from both the subform and the main
form.

When this form is first opened, an run-time error 440 Automation error
message is displayed referring to the custom function that does the
calculation. Since there are no values on the form at this point, I am
assuming that it is because the calculation in the custom function is trying
to divide by zero.

I have tried using IF statments in the function to check for zero values,
but the run-time error simply moves from the calculation to the IF statement.


Does anyone have any suggestions on how to prevent this Automation error?

Thanks.
 
Top