Hi Doru,

Actually, your question helped me also. Today I tried the same approach as you did and I found, that changing DS in a program lead to form Grids loosing their RecordSource. If I use class (not a program), I don't encounter this problem. Therefore I switched to class.

Sorry, for not being helpful in my first message. The second function, I wrote, should work fine, though it's not related to the title of the message :)

Sometimes just walking is better and safer, than riding :)

Best wishes in the New Millennium!

>>At the risk of you sending ANOTHER mean-spirited reply...
>
>Bob, I didn’t think any of the replies was mean spirited. But, with the exception of Charlie Schreiner’s, none of them was answering my question, rather tried to make me forget about my question. I asked for help to ride my new bike, and was asked if I ever tried walking… And the chorus: Walk, You better walk, walk better!
>
>The message was titled “Datasession troubles” and what I wanted was to get ideas in what was wrong in my use of datasession object, and/or any explanation of the errors I described. I had no troubles in solving the problem using any of the methods suggested – yours included.
>One problem with all of them is that, in theory, the alias of the lookup table may be in use. Sometimes I do use SELECT… INTO ARRAY for lookups, which won’t change the work area or move the record pointer, but it will open the source…
>
>
>>Next time someone replies you a question you might want to remember that they are trying to HELP you...
>
>You mean next time I… forget it, I might want to remember <s>...
>Actually, I didn’t forget this time, and I believe I thanked everybody.
>
>I thank you too!
>dz