update record when another is selected from lookup

I have a database which has two tables for "Account Details" and "Service Location".

Service Location Table
____________________
Service Location (new data)
* Domain Name Address (lookup)
^ Location Owner (auto update lookup)


Account Details
____________________
* Domain Name Address (new data)
^ Account Holder (new data)


The * denotes a relationship between tables.


I have already created this

Code:

---

SELECT [Account Details].[Domain Name Address] FROM [Account Details] ORDER BY [Account Details].[Domain Name Address];

---

To avoid manual data entry I would like to create a query for the Location Owner field in Service Location Table to auto update based on the query above.