Do i do this on load? and secondly will my subform be visible inside the parent form?
So in essence in the same form I will see form 1 and the sub form at the sametime in one form. If your familiar with access its exactly like that.
i would put a button on form1 which opens up form 2
so on the click event of the button, do the code similar to what I typed in the previous post.
if you want to make the form a "subform" of the first form, as in access, this isn't really possible. you just add a datagrid, or whatever control you want in the form. There is no reason to have a subform as they do in access. if you really want to have a second form, then look up MDI forms.