Hi,
I have the following problem,
I created a query

Code:
SELECT Customer_t.S_Street
FROM Customer_t
WHERE ((([Forms]![Order_t]![Combo45])=[Customer_t]![Billing_Name]));
and used this query to populate a combo box. My customers have multiple shipping addresses. When I first open the form and enter the value for a customer name, I get the right values for shipping addresses but when I try to change...