The SQL query I gave you is to be ran directly from your datasource. It cannot be used against recordset that you opened.

>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