I normally reset the rowsource and type after the under lying table changes.

something like
rowsource =''
rowsourcetype =''

rowsource = 'tablename'
rowsourcetype=2 &&alias
this.requery()

John