I've been looking though the archives and I can't find where some one may have had this same problem, so all ideas are welcome.

I have a form that contains 2 grids. The first grid.recordsource is a cursor populated from a sql-select. In the doubleclick event of the textbox of this grid the selected record is added to the recordsource cursor of a second grid.

Works wonderfully, but this is made so the user can change their mind. If a record is removed from the second grid, and then another record is added from the first grid, there is a blank row corresponding at the place held by the deleted record.

There are blank spaces for all the records that are deleted. The record order seems to be whacked as well. Click on a record to delete it and the record above it deletes instead. If you try to delete all the records that were added after deleting one record, the last record is visible but cannot be deleted. The deletion is being fired by the doubleclick of the textbox in the second grid.

TIA