>>>>>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
>
>I checked the record source and it is showing correctly. This grid is editable if I fill it with at least 1 record and
>then go and fill the parent record. Now if I comeback to the grid it is editable. But without first filling the grid
>if I come back to it, it is not editable. I may be on the wrong track altogether.
>
>thank you for the reply
>
>alex
Perhaps, I missed your point. I'm not familiar with your interface, and just can guess. What do you mean saying 'filling the grid'. Obviously, that you should have any recordsource (not empty) before start editing.
Edward Pikman
Independent Consultant