Thats a normal behaviour of the grid. It gets vanished whenever recordsource changes.
Use SQL View instead otherwise you will need to redefine the grid. There are some other alternatives too. Please let me know if you need more help.
>I have a grid with the recordsource set to a cursor "CurInv". I issue a SQL statement to this particular cursor (select * from x to cursor CurInv). and then my grid goes blank. I figured out that the Select statement is changing the pems of my grid. For example, I check the grdx.columncount right before issuing the select statement. It is set to 10. Right after the Select statement it is 0.
>
>Any ideas?
>
>Thanks,
>Paul
- Jayesh