[resolved] Deleting record and seeing it updated immediately

[SaharaWizard]

Hello Guys
In a form I have a little datagrid that is bound to an ADODC recordset (I know bound is not a good solution but there is a reason for using it here). This grid just lists Id and Name.
When user pick up on item in the list this record is SELECTED from database and all the details (different columns in table) is shown in various texboxes in the form (using code and not bounding).
Problem is that I want to be able to delete some of the records, hence I added a delete buton next to the datagrid and although it does delete the record the record still shows in the datagrid even after it has been deleted!!!
I have to close and reopen the form to see it gone!
I tried:

adodc1.recordset.delete
Adodc1.refresh
dataGrid1.refresh
but no use.
How can I get rid of the pesky record?
Ty in advance

[flair]

Adodc1.Recordset.Requery
DataGrid1.ReBind
Does this help?

[SaharaWizard]

Yes buddy thank your for your suggestion. It solved the problem.