>>>Hi.
>>>
>>>Can anybody tell me why this happens to me alone.
>>>
>>>I have a form with the grid. When the user click add, then the underlying table of the grid
>>>becomes a cursor created on the fly with one record containing the value of the key field.
>>>If the first click I do is in the grid, it is editable. But after editing other controls of the form
>>>if I click the grid, it is not editable. Can any body point out why so??
>>>
>>>Thanks
>>>
>>>alex
>>
>>Do you want to say that you use Cursor as Grid.Recordsource? If this cursor produced by Select-SQL command, then it's Read-Only and cannot be edited. If it's the case, you can change your code to get editable cursor (CREATE CURSOR / INSERT INTO).
>
>I am not able to send the reply to this as I have pressed some other button while the reply was being posted.
>After that it was not taking any msg.
>
>My cursor is created using the creat cursor command. My grid is editable if I click the grid control first. But
>if I come from another control of the form to the grid, it is not editable. The problem seems to be that the
>created cursor is not the current selected area when I am in the grid. Where do I say that the current area for
>the grid should be myCursor?
>
>thanks
>
>alex
If Grid.Recordsoucre="tmpcursor" then grid itself will find its work area, if you didn't close cursor programmatically during form navigation. I think yoo could 'debug' this problem e.g. checking Grid.Recordsource from some Column.Control.Dblclick
Edward Pikman
Independent Consultant