@ RuralGuy, well the thing is, the user may opt to start typing the product code, omitting the first few digits. Anyways. after trying thinking about it a little harder about my options i have managed to solve it.
Once the user double clicks the option he wishes to use, the popup form calls a public function:
Code:
Private Sub UPN_DblClick(Cancel As Integer)
VstrUPN = Me.ProductID
Me.Caption = VstrUPN
DoCmd.Close acForm, "frm_product_Search_Popup", acSaveNo
Call Form_frm_Transaction_Transfers_Detail.InsertText
End Sub
Code:
Public Function InsertText()
Me.cbo_UPNCode = VstrUPN
VstrUPN = ""
cbo_UPNCode_AfterUpdate
End Function
The function then inserts the text into the combo box and then sets the QTY field into focus.
I have added my working solution for you guys to see how i got it right.
Thanks to everyone for your assistance.