>daniel,
>your solution worked perfectly. thanks sooo much for your assistance. i have been killing myself with this simply thing for 2 weeks. thanks to everyone who responded...what a wonderful resource this is! david w.

David, actually resetting of grid.recordsource is just a beginning. You will find out soon (with UT help:), that it will involve more solutions.