Accessing a Form w/ Subform and get "value" pop up.

[Novice guy]

My start form has a combo box with multiple locations listed. Next to the combo box, I put a Information cmd button to lookup the specific information on the location. The combo box gets it's values from a lookup table

The second form being accessed by the command button contains the specific details on the location and also has a subform with an individual point of contact. Because this individual contact can be referenced by several locations, the names had to be in it's own table. I therefore created a one-to-many relationship.

The problem is when I'm on the top form and click the information button, I get a pop up window with a "value" question with a reference to the sub form. If I click OK, it works fine. If I click Cancel, the sub form doesn't show up

How can I get rid of this darn pop up box? The value in the combo box on the primary form does have a relationship with the referenced "parent" form and the sub form. They all get their values from the same lookup table

Geeze, I hope this sounds less confusing than it was to type.

 

[Guest]

I think I know what you are talking about and made changes
to ensure all columns in the tables had a value. This
apprach didn't work.

What seems to be happening is when I click the Info cmd
button, Access doesn't know what "location" to associate
the individual point of contact to. Even though I have
the relationship created, it seems to want more
information. The top of the Pop up box says "Enter
Parameter Value" and references the sub form and field
that links the subform to the parent.

If I leave it blank and hit "OK" it the proper name is
referenced and everything seems to work fine. If I
hit "Cancel", the sub form doesn't appear.