>>grid.recordsource = ''
>>select ... into mycursor
>>grid.recordsource = 'mycursor'
>>
>>Is this the way you're doing it?
>I wasn't before but I tried it and the same thing happened. But, now I am using a temporary table
>instead of a cursor and the behavior has changed. Some properties are kept and different ones go away with a table rather than a cursor. I'm trying some different things, I'll let you know when I find out what's happening.

It sounds like you have some code in or referencing your grid that's interfering with things...see if there's any, and remove all except those lines above...