I am building a form using Access 97. Several fields call functions from the same module to generate the data, One function is not running at all -- sometimes. I can tell that all other functions are running as they should always. I can tell the field in question is always receiving focus, I can tell that the function runs most of the time (scrolling through records), but it does not get called on some records. I don't see any pattern. I tried using a simple MsgBox as the first line inside the function to see if it executes; it does not execute on some records.

Any ideas or suggestions??

Thanks!
Leigh

If the function is doing calculations it may be encountering some null values. If this is the case and your function recieves a null this may be the problem. You may have to convert the nulls to zeros using the Nz function to fix the problem.

HTH
RDH