Thanks Eric!
I'll try it when I get in to work on Monday.
Will let you know how it goes.
Thanks again!

>Still not sure but could it be:

>strSQL = "UPDATE AliasA " & _
   "SET AliasAadodc.address = " & YourTextBoxThatContainsAliasBadodc.address.text & _
   " FROM Table1 AS AliasAadodc " & _
   "INNER Join Table2 AS AliasBadodc " & _
   "on AliasAadodc.phone = " & YourTextBoxThatContainsAliasBadodc.phone.text