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