Paul
It really sounds like your grid is losing its RecordSource, like pulling the rug out from under it.
Is the table closed or disappeared in some way during the running of the form?
Indeed, is the grid's source a temp. table or replenished cursor?
These are the "classic" reasons for the behaviour you're experiencing.
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.