SCRAMBLER
02-25-2002, 06:36 AM
When using a combo box to select a customer's name, I would like the address for that customer to be placed on the form automatically. How can this be done?
|
View Full Version : From Controls SCRAMBLER 02-25-2002, 06:36 AM When using a combo box to select a customer's name, I would like the address for that customer to be placed on the form automatically. How can this be done? Alexandre 02-25-2002, 11:45 AM Various ways to do that. For example, you base your combobox on a query that gathers not only the Customer s name but also his adress. you make the adres colomn of the combo invisible (ex: column width 5cm;0cm where 5cm is for the customers' names column and 0 for the adressers column). From the after update event of the combo, you uptdate the value of n unbound textbox on your form: Me.AdressTextBox = Me.CustomersCombo.Column(1) (combo columns are numbered from 0 : 1st column) Alex |