Fill field in subform with main form ID

[bkaren1203]

Hopefully I can explain what I'm trying to do correctly. I have a main form Orgs and a subform Acts. They are linked by the field OrgID. The subform Acts is displayed as a datasheet. I found some code that would allow the user to click on the ActID in the subform and the Activities form will pop up for the ActID clicked on. The user can also click on "New" to pull up a blank Activities form. When I close the Activities form, the new record doesn't appear in the subform Acts on the main form Orgs. Which means that the new Activities record field OrgID is blank. So, how do I get the Activities field OrgID populated with the OrgID from the main table so that the new Activities record is linked to the OrgID field the main table?

[June7]

Have to requery the Acts subform. Couple ways to accomplish.

1. open the Activities form with acDialog parameter to suspend code execution by the Acts subform until Activities closes, then the next line would be:
Me.Requery

2. code in Activities form Close event requeries the Acts subform
Forms!Orgs!Acts.Requery

I prefer option 1.