>>>>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