Form-Subform-Popup Problem

[TrudyD1474]

I will try to make this as clear as possible, hopefully.
I have a main form that includes farms.
Within that form I have a subform that shows each contact for that farm.
Then I have an activity pop-up form that will activate when the end user selects the "select" button for the appropriate contact. The activity is used to track the visits to the particular Contact on that particular farm.
So it is Farm Form - Contact Subform - Activity Pop-up.

When I make the Activity form a subform of Contact, everthing works just fine, all the fields fill in properly and the records are updated properly.
However, if I try to make the Activity form a pop-up, I can't seem to get it to create my many-to-one record (contact_activity), it will only create the Activity record. The problem with the many-to-one (contact_Activity) is that it won't "autonumber". All the fields are available except the "autonumber" id for the Contact_Activity.

1. Farm is 1 to many with Farm_Contact
2. Farm_Contact is many to 1 with Contact
3. Contact is 1 to many with Contact_Activity
4. Contact_Activity is many to 1 with Activity

The contact form uses a query made up of Farm_Contact and Contact


The Activity form uses a query made up of Contact_Activity and Activity

The activity form is set as a POP-UP.

So any thoughts?
Trudy

[llkhoutx]

Your popup is not filtered correctly. Open the popup, set the popup FilterOn property to Yes, and set the popup Filter is set the correct filter.