I would like to have a subform in its own window. Not at the bottom of the
main form. How does (subform in new window) on Design tool bar work?
Not the way you want.
It just opens the Form object within the Subform as a new *design* window;
this is often useful if you have a very small subform and need to "put the
pliers through a keyhole" to work on it otherwise. It will NOT change the
subform control to a popup form.
If it's just a matter of screen real estate, I'd suggest putting a Tab Control
(see the toolbox) on the form; put your mainform controls on one page of the
tab control, and your subform on the second page.
If you really want a freestanding, independent popup form, you'll need to
write some VBA code to recapture the master/child functionality of the Subform
control. You can use the command button wizard to create a button to open a
form; you'll need to then edit the code to add a WhereCondition argument to
the OpenForm method, and probably pass the linking field in the OpenArgs
method as well, with code in the second form's Open event to set the
DefaultValue property of the linking field control. It can be done without a
big hassle but it does require a lot more work!
