Hi guys
I have a main form "LittersF" with a subform "PuppyF". In the subform I have an option to select a buyer from a Combo Box "BuyerCombo".  I have a command button "AddBuyer" to create a new customer if it does not exist "BuyerF"
In the on click property event of "AddBuyer" I send the control, which is the BuyerID, from "BuyerF" to the Combo Box "BuyerCombo" in the subform "PuppyF". The "BuyerID" is not the control in the current subform. It does, however, have a relationships with the Puppy database
The idea is to have the name of the record that was created, in the combo box of the subform that is still open, when I close the "BuyerF" form.
It creates the record in the Buyer table but it does not send it to the subform.
I've tried a few options and hope someone can give me the magic answer.

This is the Row Source of the Combo Box "BuyerCombo"
SELECT BuyerQ.BuyerID, FullName FROM BuyerQ ORDER BY FullName;

This is my code:
Private Sub AddBuyer_Click()
    DoCmd.OpenForm "BuyerF", , , , acFormAdd
    Forms!LittersF!PuppyF!BuyerCombo = Me.BuyerID
    Me.Refresh
End Sub