Hello!
Thank you for your input, and with that, I now realize that there is also a place great for using a loop through recordset method though it is not as efficient as the other method.
And so I think the rule of thumb is, use action queries as much as possible; as long as it can, and loop...