I learned MS Access on my own. I started from knowing nothing about it, to being quite proficient. However since there are many different ways to do the same thing, many times I am wandering which is better. The database that I create for our company is getting quite big, as more and more data and features are added tot it. At the moment the front end is about 5MB after a compact and repair, and that does not include any data. Also the number of objects is getting quite large. In this context efficiency and best practices is more and more on my mind. The question of this post is about a form's record source. Currently I have quite a few forms that are based on select queries. The SQL for the queries are being dynamically modified with VBA to display the necessary data. This is the method I learned and that's how I am doing it. Recently however, I realized that you can have the whole SQL as the form's record source. So I could use VBA to modify that, and not use a query at all. This would eliminate quite a few select queries from the list of my objects, and perhaps simplify my front end a bit. So what are your guys thoughts on this?