No. Subform/subreport container control is component on a form or report. Like a textbox or combobox you create one by selecting the tool from the ribbon Design tab and click on form to create control. Select the subform/subreport tool and click/drag to create a box on the main form. This creates the container. Now set the ObjectSource property of the container to the object you want it to hold (table, query, form, report). Just as demonstrated in the video. You must understand that a subform is constructed with a container control that holds an object. I have already described and the video demonstrates how to select a container control already on a form. I suggest you review the video again and other tutorials if needed and reread earlier posts. I cannot help you any further until you understand how a subform is built.
The code you show in first post is setting form recordsource to display records that meet filter criteria. If only one record meets the criteria then that is all that will show on the form.