Thanks for your help, the problem was that I was changing the information for the grid while it was still connected to the grid. I needed to set the recordsource for the grid to '' before I changed the data to be displayed.

Thanks again.