Dim db1 As DAO.Database Dim tbl1 As DAO.Recordset Dim tbl2 As DAO.Recordset Set db1 = OpenDatabase("C:\mydatabase.mdb") Set tbl1 = db.OpenRecordset("MyTable1", dbOpenTable) Set tbl2 = db.OpenRecordset("MyTable2", dbOpenTable) Update AliasA SET AliasA.phone = AliasB.phone FROM tbl1 AS AliasA INNER Join tbl2 AS AliasB on AliasA.address = AliasB.addressThank you so very much! I really appreciate it!