Senna-

I've never used the repaint method so I don't know if it has anything to do with your problem or not. But I think you would do better to have a specific method that you call to refresh the grid when you know that the crosstab has run.

Do you mean you set the rowsource = "" before you run the crosstab?

>I set columncount=0 and recordsource=' ' before, but the result isn't good enough.

>I'm building a grid with a crosstab recordsource, everytime the crosstab fires, grid always changes it shapes, so I made grid shapes programatically ,I put a blank grid to a form, then changes all the properties needed in grid.repaint() method, so everytime crosstab code fires, I have to make this.grid.recordsource to default (" ") and also columncount, then the grid repaint itself in repaint() method.
>I also create a possiblity to add a new field or remove existing field to the grid.controlsource and that makes the grid have to add or remove column.