>Now all I've got to do is work out how to change the rowsource of the grid without losing the characteristics (and the dblclick activity)

I'll make it easy for ya', set the RowSOurce to "" before you change it.