• New Record in a Subform

    Author
    Topic
    #356286

    New Record in the subform

    I have a main form called ForderInformation and a subform called ForderDetailsextended. Thee linked fields are orderird in the main form and in the subform.
    The productid in the subform is a combo box from where I can choose the products from a dropdown list.The after date event is the following
    DoCmd.GoToControl “productid”
    DoCmd.GoToRecord , , acNext
    However it woirks only the first time, when I choose the first product.If I choose a second product I do not go to a new record but I stick to the previous one.
    Can somebody show me where my mistake lie?

    Viewing 0 reply threads
    Author
    Replies
    • #527043

      have you tried requery
      me.requery
      at the end of the code

    Viewing 0 reply threads
    Reply To: New Record in a Subform

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: