>>
>>Yes, ControlSource is set to a field in the view. Are you saying that using InteractiveChange in this case is no good?
>
>I've found in some cases it helps to put a DODEFAULT() before your own code in InteractiveChange, IOW let the control update itself (and possibly a bound ControlSource) before doing your own processing. It's instructive to step through your code in the Debugger and watch the control's value, the bound column's value etc.
I do have DODEFAULT() before my code. As far as debugger, I have been having tough time watching the code in debugger. I think I will put some code to write to a "log" file (instead of debugger) to see how the values are changing.
Thank you for your suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham