Combobox on Form

[WJReid]

Hi All,

I have a form based on a query and I want to replace my order number textbox on the form with a combobox. How can I get all of the other details in textboxes to adjust along with the selection in the combobox?

Regards,

Bill

 

[parry]

G'day Bill, install the Northwind example database if you havent already done so and look at the orders form. By changing the "bill to" box other details are amended. See the before & after update events for the control.

 

[WJReid]

Hi Parry,

Thanks for the help. I had actually put an unbound ComboBox on the form and linked the fields, but the information did not automatically fill in. However,when I put the ComboBox on with the Wizard, I got the correct result.

Thanks again for your help.

Regards,

Bill

 

[dtaylor]

Hi There..
on the after update event on the combobox put in

ME.REFRESH

this will refresh all objects on form with every selection from combobox.


Dan