Linking Main form and sub-form to second form

[Nancy]

I have a main form with a sub-form. I want to place a Check box on my main
form. When the check box is clicked, I want another form to open and
auto-populate with the selected information off the Main form and sub-form.

I know how to place the check box and do the macro to open the second form.
But I am not sure how to limit the information that auto-populates. In other
words, I only want the second form to auto-populate specific records when the
check mark is clicked.

For example:

I may purchase 15 parts on 15 different purchase orders. Of the 15 parts, 4
may require us to return a core part. Let’s say purchased parts 4, 7 and 8
require a core return. On the main form I want to be able to click on the
Core check box and have the second form open to the core information form.
On the core information form, I want the basic information to auto-populate
the core information form, and I will manually fill in the additional fields.
But I only want that specific record to auto-populate the core information
form. I have it working now, but it auto-populates all records to the core
information form. I know I have to limit the records to the core information
form, but not sure how best to limit it. Once I have this concept down, I
will be doing the same concept to track warranty items.

My main form is: F_PurchaseOrder
My sub-form: Order Details Sub Form
My second form: F-CoreInformation

Thanks so much.

 

[Beetle]

If I understand correctly, you have a main form (F_PurchaseOrder) that
displays general info about the PO, and a subform that lists all of the
parts on that PO. If so, then it would seem like your core check box
(as well as the underlying field) would be in the subform, not the main
form. Then you would use criteria to find part numbers where the PO
number is XXXX and the core checkbox is true. If you have the check box
(and the related field) tied to the main form, then Access is going to assume
that every part on that PO requires a core.

Then again, maybe I'm missing something

 

[Nancy]

Thank you for the response. And that makes perfect sense. I guess I wasn't
even thinking...