Unanswered: Copy record from combo to subform on dbl click
I have this order form with a subform where you can type the order in and a search combo box where you can filter records. Once you find the right record you should be able to dubble click on it and the PCODE should be copied to the sub form and completed in a new record.
I've tried a lot of possibilities but i can't get neither of them working well.
I've tried copy the recordset, i have tried with add new,
i have even tried with go to AcNewRec
Private Sub Knop182_Click()
DoCmd.GoToRecord acDataForm, [Bestellijst sub formulier], acNewRec
[Bestellijst sub formulier].[PCODE] = 100