With help from tek-tips users I have successfully created a function called CalculateAll that carries out a number of calculations based on a value in a recordreturning the results in an array from which I extract values to populate fields on a form at the on current event. calcfield(0) calcfield(1) etc etc
I would now like to use the same function to populate fields in a query is this possible, what is the syntax and how would I pass variables to the function?
I would now like to use the same function to populate fields in a query is this possible, what is the syntax and how would I pass variables to the function?