>Haven't tried the SQL approach. The table where the report comes out loads in the report DE, not in the form. I have reindexed the table, but to no avail. I also believe that if it was a problem with the table I should be getting the same error in the development environment too. I'm thinking it may be something to do with corruption of the form file. I'm recreating the form at this time.
>Thanks for the reply.

What's the buffering on the table in the calling form? If you make changes there, have you saved them to disk before calling the report?