Sometimes the record is deleted and sometimes a filter is changed so that the record the pointer was on is no longer included in the grid. Either way, I set the recordsource property of the grid to "" and then do my deletions in the table or change the filter or perform a new query, etc. I then decide where I want the record pointer to be in the table (either on a specific record (if doing search) or at the top of the file or at the bottom of the table. Once that is done I reset the recordsource property of the grid. Following that I perform the scroll in my code so the appearance in the grid is acceptable. Typically the appearance is ok unless the record pointer is at the last record in the table in which case by default it would be the only row showing in the grid and I scroll the grid so some of the records above show in the grid.
>Tracy,
>
>Thanks that seemed to mostly help. I have one question though. In your example what are you doing to the record behind the grid (datasource/recordsource)? Because that seems to be the biggest part of my problem because of the update command my pointer is moved and that seems to be messing up the display. Even when returning to the right place with a go statement.
>
>Thanks again,
>
>Troy
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"