List box V/s Combo populating form fields(thanks in Advance)

[Guest]

I have two tables one store all date concerning a client , the second store
suppliers name, address, city, state and zip what I would like to do is
select the information from the second table (supplier) and have it populate
the form. my problem is how to I get it to populate all 5 fields and which
would be a better choice list or combo

 

[Guest]

Terry,
A great way to do this is to set up a combo box with all 5 fields that you
want to populate elsewhere. You do not have to show all the fields but in
order to hide you would need to make their width 0", they still need to exist
in the box.

You will need to have all the fields that need the info on your form, they
can be set to not visible. Then on the After Update event of the supplier
combo box put the code similar to the following:
Me.SupplierAddress = Me.Supplier.Column(1)
Me.SupplierCity = Me.Supplier.Column(2)
Me.SupplierState = Me.Supplier.Column(3)
etc.

This example is where the combo box on your form is named Supplier and the
columns represent the columns in the combo box (starting at 0 as the first
column).

Hope this helps. Let us know if it does not make sense.

Jackie

 

[Guest]

I have the same problem but three of my fields are not text. They are memo
and 2 OLE objects. Any ideas, since those 3 don;t show up as options when I
create the list box/combo box?