Hi Carl
Assuming the customer's address is on the CustomerF, you are trying to have the address be on the order form. You need a way to bring that information to the fields on the order form. Here is vba that Richard use in his App.
Adapt as needed.
Private Sub Form_Current()

    LockIfShipped

    If IsLoaded("CustomerF") Then
        CustomerCombo.DefaultValue = Forms!CustomerF!CustomerID
        Address.DefaultValue = """" & Forms!CustomerF!Address & """"
        City.DefaultValue = """" & Forms!CustomerF!City & """"
        State.DefaultValue = """" & Forms!CustomerF!State & """"
        ZIP.DefaultValue = """" & Forms!CustomerF!ZIP & """"
        Country.DefaultValue = """" & Forms!CustomerF!Country & """"
    Else
        CustomerCombo.DefaultValue = 0
        Address.DefaultValue = ""
        City.DefaultValue = ""
        State.DefaultValue = ""
        ZIP.DefaultValue = ""
        Country.DefaultValue = ""
    End If
  
End Sub


Please show me the code for you issue with totals. I need to see details

John

Maybe I need to explain better, What I have so far I did to get the info I want and to have it recorded the way I need. There is probably a better way but I am at a loss to figure it out.

I have 2 separate tables, "CustomerT" and "ShipToT" (See "CustomerF").

The Shipping address is never the same as the Ordering Customer that is why I omitted the "Same as button".

What I need is when I click the ShippingID combo for it to show only the shipping addresses for the current customer on the Form. Currently I have included the Customer name in the combo box so I can identify. I tried using a subform but for some reason it did not record the information correctly. The information currently is being filled with DLookup.

Carl, your first problem with the Ship to: you need a WHERE clause at the end of your control source combobox (before ORDER BY) to limit the selection to that customer:

... " WHERE CustomerID = " & CustomerID

This is all I have on the Order Totals. I have just used a Unbound text box and put the formulas in the line totals ie "ExtPrice", "TaxRate", "ItemTotal" I want to total these three columns in the footer. I tried using the query method Richard described in the video but did not record the information the way I need. I may be missing something but I tried it 3 times. What am I missing?

Sami, I think I am missing something it still lists all shipping addresses.

Check your double quotes in the code above. It is not correct.
Check this great video
Double Double Quotes

When I put just a single quote I do not get any data in my list.

Watch the video

Hi Carl
Sami is correct. The WHERE will limit your list as you wanted. DoubleDouble quotes are a little confusing, so bear with it.


John

Hi Carl
Take a look at Richards Expert 29 Lesson 01. I think it will help you with your totals. You might check his code on the actual form/report

John