I think if someone were "of a mind", a combination of the things you did and what Gina did would be very useful.Not for the main functionality.
There is one UPDATE statement but that's only where users want to save the combo setting on the VBA tab as the default.
Suggest you look at the code if interested in knowing more
The reason for VBA queries, whenever possible, is so you don't end up with a 1000s of querydefs.Just a thought.
! was told, in general, the answer is a query.
I use queries wherever possible. I use code, when I can't do it with a query - perhaps the query is non-updatable.
It's hard to get the precise percentage, but a good deal of my code is defensive - controlling the look and appearance of the dbs, checking for legitimate values, confirming that user input and so on.