
Originally Posted by
Micron
Provided the more extensive query isn't a resource hog or something, there's nothing wrong with using the more extensive one and only using the fields you need for any given form. While I probably wouldn't use a 24 field query as a source for a 3 field form (for example) you make it seem like they're quite similar, so that's where I'm coming from.
Some don't seem to like queries with parameters (to each their own but I have no such issue) but that is another option. A third is to use vba based sql, which can be harder to conceptualize. The upside is that unlike a compiled Access db where query sql is still visible, no code, thus no query sql, can be viewed when it's all in vba. It tends to make the db smaller to start with.