Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    69

    Arrow 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
    End Sub


    Anyone an idea ?
    Attached Thumbnails Attached Thumbnails orderform.JPG  

  2. #2
    Join Date
    Sep 2003
    Posts
    69
    what i tried was
    Private Sub Knop182_Click()

    DoCmd.GoToRecord acDataForm, [Bestellijst sub formulier], acNewRec
    [Bestellijst sub formulier].[PCODE] = [name_of_listbox].[pcode]
    End Sub

    the pcode from the listbox (or combobox) is the return value so i should be able to put it in the order sub-form but i don't know what command to use to fill it in.

  3. #3
    Join Date
    Sep 2003
    Posts
    69
    nobody can help?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •