Pulling default address from another table

[Coolboy55]

I have a Customers table with an Address field. I also have an Orders table with a DestinationAddress field. When a customer is selected on the Orders form, I'd like to have a command button that when clicked, pulls the selected customer's default address from Customers.Address and copies it into Orders.DestinationAddress.

The command button is named DD. I have:

Private Sub DD_Click()

If Me.DestinationAddress = Null Then

Me.DestinationAddress = "=SELECT [Customers].[Address],[Orders].[CustomerID] FROM Customers INNER JOIN [Orders] ON [Customers].[CustomerID]=[Orders].[CustomerID];"

Else

Me.DestinationAddress = Null

End If

End Sub

[Coolboy55]

I figured it out. This thread can be deleted.