>>>>I am in grid textbox VALID event and I issue APPEND BLANK follow by REPLACE follow by THISFORM.REFRESH (or grid REFRESH). The record pointer moved to the first column of the same record and didn't move to the APPENDED record. Am I supposed to issue GO BOTTOM and something of the sort?
>>>>
>>>>My grid's table is on optimistic table buffering.
>>>>
>>>>I have seen this during my previous project and can't remember what is the problem. Anyone can tell me?
>>>
>>>Tai, are you sure that you have used TableUpdate to clear the buffer on the file when you append your blank record before your refresh?
>>>
>>>Also, if your grid refresh may SELECT a parent table, which will automatically re-set the record pointer on the child tables. Try saving the record # or ID value of the new record and explicitly moving the pointer to that record.
>>>
>>>Barbara
>
>Sorry. Accidentally press the send.
>
>By the way, thanks. Exactly what you said, the child table pointer was reset because my navigation class selects my master table on refresh. I will try to see how I can solve the problem.
>
>Just a sidetrack, when I have parent-child-grandchild form with the child and grandchild in grid, the grandchild is not set to table-buffering automatically by VFP. Is this by design? My form is set to optimistic.
>
>Once again, thanks.

I have a part of the coding as follow:

APPEND BLANK
REPLACE pagr_key WITH pa_grade.pagr_key, roll_no WITH cRoll_no
nWorkarea=select()
nrecno = recno()
THISGRID.REFRESH()
select (nWorkarea)
go (nrecno)

I got the error 'record is out of range'. I have checked that the table before append and after refresh is the same (by using messagebox) and that the appended rec no is -ve. What can go wrong?

This is bad... I hope you can give me some clues.

Thanks.