Updating values of a combo box created with a query

[Efecan]

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

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 the customer name, the values for shipping addresses does not change in the combo box. I get the address values for the first customer entered. However, when I close and re-open the form my combo box shows the right values.

I am using MS Access 2003, SP2

How can I do this, so that I don't need to close and re-open the form every time?

Thanks,
Boray

[MMcCarthy]

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

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 the customer name, the values for shipping addresses does not change in the combo box. I get the address values for the first customer entered. However, when I close and re-open the form my combo box shows the right values.

I am using MS Access 2003, SP2

How can I do this, so that I don't need to close and re-open the form every time?

Thanks,
Boray

You need to requery the combo box in the After Update event of the Customer Name textbox.

Me.[Combobox Name].Requery

Mary