Ah, I see.

Could you not have have an imbedded select in the INSERT statement so you are inserting into just the selected records? Not sure how that would work though. Again, really rusty and I don't even have Access at work to test this stuff...