There is a project adp. In it, a tape form with products, the idea is as follows: the user enters the quantity of goods into the free field, clicks the "Add to cart" button on which the stored procedure is called and adds the entered quantity of goods to another table. I understood how to call a stored procedure and pass a parameter to it from the current record. But I don’t understand how to make it possible to write different values ​​in the free field. Now if you enter into one of them the value is duplicated throughout the column. Free field column

Tell me how to make sure that the values ​​of the free field of one line are not duplicated in the whole column?

    1 answer 1

    Standard means None. You can display the required field in the form header and then it will be displayed as one column and change (or not) when you go through the records enter image description here .

    • Thanks for the answer! Are there any non-standard ways? - SHSERG
    • There is. Insert 2 subordinate forms into a simple form on 1 place the field and the button, on 2 s, but the ribbon form itself and move this form using vba to the right place when navigating through the records of the ribbon form, but this is a topic for a separate offtopic. You can try to google this implementation. - Jackyt1988t