hi,

before you do something to the recordset your must set them to nothing then execute again your code.... or rebind the grid or refresh the recordset...



>First, thanks for your advice.
>
>My DataGrid is binded to an ADO Data Control, so I use:
>
>ADODataControl.RecordSource = "SELECT....."
>ADODataControl.Refresh
>
>DataGrid.ClearFields
>DataGrid.Rebind
>
>I try your example, changing the ADODataControl.Recordset property, but I get the same error.
>
>
>More ideas????
>
>
>Thanks again.
>
>PD: Can I to bind a DataGrid directly to a Recordset in run-time???