combo with query

[Jason Frazer]

I have a form that references a query.
The query combines product info with customer info.
The two have a relationship by customer number.
I have a combo box that refences the customer table so you
can select the customer. The only problem is, after you
select the customer or change customers it does no update
the address, city and etc... because it all references
the query. How can i get the form to update the query
infomations without closing and re-opening the form?

Thanks for your time and help

Jason Frazer

 

[Doug]

-----Original Message-----
I have a form that references a query.
The query combines product info with customer info.
The two have a relationship by customer number.
I have a combo box that refences the customer table so you
can select the customer. The only problem is, after you
select the customer or change customers it does no update
the address, city and etc... because it all references
the query. How can i get the form to update the query
infomations without closing and re-opening the form?

Thanks for your time and help

Jason Frazer
.

Control name.requery