Hello,
I need advice with the following code

I need to have recorded any new value created in the first recorded

sample

I'm having difficulty understanding your request. Please elaborate.

i need copy all records(rows table) from previous record (first record) to each next record
result - each record will be same

i need copy all records(rows table) from previous record (first record) to each next record
result - each record will be same

I'm with vbaInet on this. You are copying records - the same values - and that violates the rules of Normalization. So, we're trying to understand your business requirements and why you are actually doing this because it doesn't make sense from a properly normalized database perspective.

i need insert values from table tab_material_add to table tab_material

in tab_material i have autonumber field

i try this code

Private Sub Form_Click()
DoCmd****nSQL "Insert into tab_material (ROHS) Select ROHS From tab_material_add "
Me.Requery
End Sub

thank you

here is sample

Yes we understand your requirement but that's the wrong way to go about this. You shouldn't have the same records and the same fields in two separate tables.

i need change records in table, add and remove or edit records

Change the records to that table, don't insert it into another table.

Use a query for adding/editting to that table for that specific MaterialID. Run the query to filter the records. Then use the query as your form's Record Source.