>>>>this.value = this.value ?
>>>>
>>>>If THIS.VALUE is not equal to itself already, what can it be equal to? :-)
>>>
>>>This kind of tricks sometimes helps to "refresh" underlined controlsource with the new value. Ed's idea with replace with work as well, of course.
>>
>>Using no controlsources gives different angle. Btw, in this thread, I have a suspicion that Mark needs in neither the controlsource, nor the cursor, nor the datasessions, etc.
>
>We may never know unless we see some code :)
Let me venture: every container does a search (run Select statement with parameters stored in the cursor field). So the first thing would be gettting rid of the cursor and just using Container.Controls collection to get all needed Values. Next thing is that SQL collects data to the cursor of the same alias and if each container is supposed to show different recordsets then datasession requirement comes to play. If each container would have a finalcursoralias property then all session objects can be thrown out.
Edward Pikman
Independent Consultant