Opening a sub-form from a command button

I have a sub-form with in a main form. The sub-form opens with the form. I
want tthe sub-form to open separtely, such as with a command botton.

And if this cannot happen, then I want to delete the sub-form and have the
form (that was the sub-form) to open with a command button, but for it to be
sized to fit with in the area that the sub-form had opened in.

I acually have several sub-forms that open with the main form, each with in
their own page. The the database on the server and with multible users, the
database slows way down.

I want to open each sub-form as needed (instead of as the user moves to
another record). Each form would also need to close as the user moves to an
other form (sub-form), or when moving to the next record.
--
Preston