How do I open Form2 from Form1 based on data in a field in a linked subform?

[KeriT]

I have a "Main Form" (Switchboard) that opens my "Person Form". The "Person Form" has a subform "Program" where there can be multiple programs/person. Each Program goes thru different stages: "Application", "Approval", and/or "Denial".

What I want to do from my Main Form is open all records of those who are in "Applicant" status.

[Seth Schrock]

If there are times when you don't want this filter on the subform, then probably the easiest way would be to pass the Person Form an OpenArgs value when you open it. You would then use the OnLoad event to see if the value is there, and if it is, filter your subform.

[KeriT]

I am concerned about the use of the "OnLoad" event. On my Form 1, I have a button to open the person form and see all records. I also have a button to open the Person form and go to a new record. I have a third button, and when pressed, I would like it to open the Person form, but only show those persons who have "Program" records in the "Application" phase. The way it would know the record was in application status is because [w_status]=1.

Does this change your reply? Is this even possible?

[Seth Schrock]

That doesn't change my answer at all. When you open the Person form and want all the records in the subform, leave the OpenArgs blank. If you want it filtered, then set the OpenArgs to "Filtered". Then in your Person form's OnLoad event test for the OpenArgs value to be "Filtered" and if it is, then filter your subform.