Forum Discussion
Add pop up subform to add records unique to one field
I would not open a second form. I would embed the subform in a subform control on the main form and use the Parent/Child Linking Fields property of the subform CONTROL to handle the related fields.
That said, I'm not sure I follow the exact process anyway. Why are you not using the Primary Key of the table bound to the main form as the Foreign Key in the related table?
It might be easier to explain the process as i understand it. I have a field i'm calling MetricID in the main table/form. I created a 2nd table/subform with the MetricID field. This field will produce at least one set of numbers called MetricTag and MetricWeight. In most cases, it will produce many sets of numbers. The idea I had was to create a button next to the Metric Field in the main form that would open the dialogue box containing the 2nd subform. This didn't work, so I decided to place the subform in a tabbed field on the main form. I feel like I'm headed in the right direction, but I'm still having trouble. I will try to work with the controls like you suggested. Thanks again for your help.