Method to Change source of a Form’s Subform Source to a Query or Table in Microsoft Access

DRANK

IntroductionIt is often desirable to show different data in a Microsoft AccessForm. This would be done using a Subfrom. There are some choices.The normal solution is fo have multiple Subform controls on a From and make only one visible. One of the things I dislike about this solution is that it clutters up the Accessproject with all those Form objects, and there is no way to organize all these modules using objects. Using a Subform is the default when the desired view is a DataSheet view; as far as I can tell there is no particular advantage of building a Form that is to be displayed in a Subfrom only in DataSheet view. An advantage of using a Form is that then only the fields that have associated controls will be visible, but this could also be accomplished in a query by deselecting the Show (same as not including them in the Select part of the SQLclause), but this is only possible in a Query. A disadvantage of using a form and that is that if there are field changes in the underlyin…