>Dear all
>I have a child table and try to creat new command botton for adding a new record on the child table. But how to make the cursor move to the new line and first colunm automatically? (in the grid).
>
>And automatically sort by the first column after adding it.
>
Just call the Setfocus method of the control you want to have focus:
THIS.Parent.grd.Column1.Text1.SetFocus()
The grid should jump to the current record in the table.
>Also my delete command botton won't get rid of the record. It shows still and I already put thisform.refresh. Sometime it works, sometime, it doesn't
Even when SET DELETED is ON, you have to move the record pointer away from the deleted record before it will go away. My delete code goes something like:
DELETE
SKIP
IF EOF()
GO BOTTOM
ENDIF
Erik Moore
Clientelligence