Access 2000

[K]

In access how do you do this. From a pull down menu in your form you select
the business you want. How do you automatically get the address of that
business to display on the form with out typing the address in.

Thanks,

 

[Michel Walsh]

Hi,


You can use a combo box with multiple columns (some hidden, if
appropriate), and in the after update event of the combo box:


Me.OtherControl = Me.ComboBoxName.Column( i )


where i starts at 0 for the first column of the combo box.



Alternatively, you can use a DLookup, to push the data in the other control.
In some cases, you can even use a Query, rather than a simple table, as
RecordSource, for the Form, and make use of the autoLookup feature in Jet
queries to automatically get the related records of the referred table, once
its pk is selected.



Hoping it may help,
Vanderghast, Access MVP