Updating From One Table to Another Based on an ID Match

[SHAMI]

Hi all comrades

please , how to update a table2 record based on alter a similar record in table1 with specified Id by a vba or query statment ?

Example in attachment .

[CarlettoFed]

It makes no sense to have two tables that are the same.

[SHAMI]

the sense is (The second table is linked table from a network server ....)

[Bob Fitz]

the sense is (The second table is linked table from a network server ....)

I still don't understand the need or two tables that are the same.
Why not use the linked table as the record source of the form?

[SHAMI]

thanks you all
solved just now by a close friend with vba code .

Private Sub Sv_Click()  
    Dim db As DAO.Database
    Dim rst As DAO.Recordset
    
    Set db = CurrentDb
    Set rst = db.OpenRecordset("Select * From Table2")
    
    rst.FindFirst "ID=" & (Me.ID)
 
    If Not rst.NoMatch Then
        rst.Edit
        rst!DName = Me.DName
        rst!Age = Me.Age
    
        rst.Update
    End If
    
    rst.Close
    Set rst = Nothing
    Set db = Nothing
End Sub