Combo Boxs

[DaveB]

Can I do a combo box so that when I start typing text in
one field, it will choose multiple fields from a
different table and complete all of the other fields in
original table also? What are the steps to do this?

 

[Michel Walsh]

Hi,


On way to do that is to have multiple columns in your combo box list (even
if they are invisible). In the After Update event of the combo box, push the
other columns in the appropriate controls:


Me.OtherControl = Me.ComboBoxNameHere.Columns( 5 )

would push the content of the 6th column ( first one is 0 ) into the
mentioned OtherControl. Repeat the line for the other controls to be
associated to the other columns.


That may not be very acceptable if the list has a large number of rows, in a
multiple users environment.



Hoping it may help,
Vanderghast, Access MVP