Debugger (which i'm not really famaliar with) only gives locals for the spinner as my entire database. I'm guessing it's trying to give me a clue?
I'm also guessing that you're saying that the problem is in some of my function code somewhere and debugger is going to help me find it?

>>If the value in Spinner1 is chosen first, then the value of other controls, the value in Spinner1 interactively changes back to zero. what could be causing this?
>
>Put SET STEP ON in the lost focus of spinner. Then step through the code and monitor the value of the spinner. Also, in the debugger you can set a breakpoint on the value of thisform.spinner1.value and the code will halt when the value changes.