You can also add a subform to a form, which we’ll call the main form. Access interprets the subform (an object) as another control, and the subform, like other controls, has properties.

Now, if I open up the subform by itself in Access, I notice that the form now has a RecordSource.<br><br>I'm wondering if it's even possible to alter the recordset of a subform, and it might not ...

If users need to access data that is not on their forms, you could add a subform; or, you can add a command button that, when clicked, will pop open the form that contains the necessary data. Find ...