>I have a problem with the grid control. If I do the SQL statement again, the grid becomes a blank area. Why? How to resovle this problem?
>
>Thanks,
>
>Raymond

Raymond, issuing SQL statement again trashes your grid.recordsource.

Before doing SQL again you have to reset

grid.recordsource = ""
* SQL statement goes here
grid.recordsource = "mySQLcursor"

If you set up the individual column.controlsource you also should remember/reset each column.controlsource.

Nick