Thanks for your help Eric!
If it's ok I have a question regarding how to use the alias with the table. Would this the the way to code it?

  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.address

Thank you so very much! I really appreciate it!


>You need to use aliases. It will be something like this:

UPDATE AliasA
SET AliasA.address = AliasB.address
FROM Table1 AS AliasA
INNER Join Table2 AS AliasB
on AliasA.phone = AliasB.phone