strSQL = "UPDATE AliasA " & _ "SET AliasAadodc.address = " & YourTextBoxThatContainsAliasBadodc.address.text & _ " FROM Table1 AS AliasAadodc " & _ "INNER Join Table2 AS AliasBadodc " & _ "on AliasAadodc.phone = " & YourTextBoxThatContainsAliasBadodc.phone.text>Sorry I didn't explain exactly what I wanted. I think I'm going about this the wrong way because what I was asking earlier is really a doing things the hard way. I guess what I want to happen is for the address information to be inserted autimatically into the text box (after it finds the same phone number exists for both tables after losing focus on the phone field) but since the form is using an recordset for the tables the data really won't be sent to the table until it is saved by the user clicking the save button. (MyTableadodc.Recordset.Update) So I would want the address information to be retrieved and placed in a text box but if the user cancels the recordset (or closes the form) then no information is sent to the table.
>UPDATE AliasA >SET AliasAadodc.address = AliasBadodc.address.text >FROM Table1 AS AliasAadodc >INNER Join Table2 AS AliasBadodc >on AliasAadodc.phone = AliasBadodc.phone.text >>