open subform in new window

[Guest]

I have a form created which collects information from grantees regarding
their activities throught the reporting period. With this each grantee needs
to be able to enter multiple objectives and specific questions regarding each
objective. Therefore I have a KeyOutcomes table and an Objectives table
linked one to many by ID. I would like to have a button to open the
objectives form, but I cannot figure out how to do this and maintain the
ability to autolink the records that you get by using a subform. Is there a
way to open a subform with a button instead of viewing the subform inside the
parent form?

 

[Guest]

This will not work with a subform. A subform is always embedded in the
parent form. What you can do, however, is create a separate form that will
contain only the records related to the current record in the first form.
You can accomplish this with the Where argument of the OpenForm method.
There is a good example of that in the VB editor Hlep.