How do I Open A Subform Based on a Value on Main Form

[jboyle]

I have a table that contains data for manufacturing processes. I have a bound object frame to display a flowchart for the different processes. As the user scrolls from one process to the next, the flowchart is displayed on the form. What I would like to do is to have a subform appear that is related to the process name that is displayed on the form. Any help would be appreciated.
Thanks - John

 

[DaveMere]

Try attaching the subform using the Wizard. It will ask you to define Master and Child values for the subform. Define the Master Value as the process name and the child value as a corresponding foreign key in your subform data table. Presuming the database tables you are using for data are nicely relational, and of course the process name you are referencing as a Master value is unique within the table (otherwise use a unique key), the subform will reference the Master/Child values you have specified as a foreign/primary key relationship.