Function called from form returning #Error - Please help!

[andy49]

I wonder if access is seeing a circular reference as you variables in your function are the same as the field titles. I've seen this as an issue before.


Sent from my iPhone using Tapatalk

[davegri]

If this code is in a module, you can test it in the immediate window:
?AverageAVM(2,2,2,2,2,2,2,2,2,2,2,2)
Should return 2.
You can also use the breakpoint, then F8 to advance one line at a time.

The calls for old and curr should not be in the function itself.
Please show what the data source is for the textboxes that are receiving the results of the function.

[Quanada]

I put the calls in the code as comments for the purpose of this post I will try the immediate window... Thanks for the help guys! I will figure it out... Andy, you may be right about the circular reference as all the names are the same: table, form, function...

[andy49]

Cool. Just make sure you post how you solved it


Sent from my iPhone using Tapatalk