** HELP!!! ***Insufficient base information

[dwong]

Hi,

I have a Datagrid bound to an ado control. The datagrid displays list a to do list whereby, the aim is for the user be able to update any columns and add new rows.

Whilst I am able to update the column, when I move the cursor elsewhere on the same row, its is OK, but trying to exit from the form will produce the message "Insufficient base information for updating and refreshing".

Also, when I update a coloumn and move the cursor to a different row, immediately the above message appears.

I have been look at this for quiet some time and don't have any ideas. The data table has a primary key defined so I am not sure why this message is appearing.

Any ideas out there? I don't have any coding for the datagrid apart from changing the ADO commandtext as per below:

AdodcProjToDo.CommandType = adCmdText
AdodcProjToDo.RecordSource = strSQL
AdodcProjToDo.Refresh

'*** Reset Command type back to table
AdodcProjToDo.CommandType = adCmdTable
AdodcProjToDo.RecordSource = "project_To_Do"

I have not coded an update SQl because I believe this should had been catered for by the Datagrid/ADO control.

If I am wrong, please let me know and indicate which event I should include the update SQL.

Thanks in advance...

 

[vb5prgrmr]

This is just a guess but check to see if the feilds that you are leaving blank are required, or if your query has an order by in it, that may be the problem also.