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?