I have a grid which is bound to a cursor. When i click on a particular record in the grid the form displays my information with regards to that record. If I modify the status of the record I requery the cursor as the status is shown on the grid with the record.

The problem I have is that I use the doscroll(2) so that it shows all the records in the grid. But when this happens the row highlighted is the first row in the grid even though the record I am on is say the 5th (Very confusing to the user!!). If I remove the do scroll I get the results I want but it puts the record I am on at the top of the list which looks like there are no more records above until I scroll upwards!!

I cant win with this!! Anybody experienced a similar problem. I want to show all the records in the grid and highlight the actual record at the same time.