1) Set the value of the select list to the id_prod column
2) Add a recordset to the page to filter based on the the id_prod submitted from the select list
3) Then you can use any other columns from the recordset to set the values for the insert
thanks for your reply.
2) how can I do this in the same page as the form without reloading the page?