In your form Selection, maybe for your popup form button
Code:
Private Sub Command2_Click()
Forms!frmCompany.sfrmCompany.Form.TxtLocationID = Me.CboLocation
DoCmd.Close
End Sub
I see that your code won't fire if there was a value there and it was changed. Currently that means that the id value won't change but the combo value will. Not only that, you can't cancel the popup if you made a mistake on the subform combo selection. I'm speculating that one might realize that based on the selection you expect certain list values. When you don't see what you expect you look at the form and think "shoot, I picked the wrong value. Now what? I can't cancel." Maybe that's not the case, but it's generally not a good idea to present an input form with no way to cancel.
Last edited by Micron; 03-06-2021 at 01:49 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.