>>how do you refresh a grid? I have one with the following
>>WITH THISFORM.grid1
>> ROWSOURCE= "Select price,quantity,noun from trans"
>> ENDW
>>and a click of a cmd button does the following :
>>SELE TRANS
>>GO TOP
>>DELE next 1
>>PACK
>>the grid goes empty after clicking. I've tried refreshing the form too.
>
>You may want to select into a cursor, then set your recordsource to an alias of the cursor. Then when you want to refresh the grid set the recordsource to " " then run the select statement again and reset the recordsource to the refreshed cursor. Keep in mind you will lose some property settings doing this type of refresh.
Instead of using "with thisform.grid1 ...recordsource=ytemp..endwith"
I used "thisform.grid1.recordsource=ytemp"
and it worked. How do you explain that, I thought they both accomplished the same thing.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."