Auto fill-in

[Jodi]

I have a form that has a combo box for shippers/consignees.
The combo box brings up the shipper/consignee name,
address, phone and misc info. I'd like to change this to
be a combo box for the shipper/consignee name only and
have access auto fill-in the address, phone and misc info
into 3 new fields. Any help would be greatly appreciated!

 

[Guest]

There are many ways to accomplish this, but this way doesn't require too much code

Leave your combo box pulling data for the name in column 1, address in column 2, phone in column 3. Set the "Column Widths" property of the combo box to: 1";0";0
Set the "Column Count" property of the combo box to:
Only the Name will show in the drop dow
(You can change the first value if you need to show more of the name
Use this code for the AfterUpdate event of the combo bo

Private Sub combo1_AfterUpdate(

Me.Text1= Me.cboEmail.Column(0
Me.Text2 = Me.cboEmail.Column(1
Me.Text3= Me.cboEmail.Column(2

End Su

You can add other columns in a similiar fashion

----- Jodi wrote: ----

I have a form that has a combo box for shippers/consignees
The combo box brings up the shipper/consignee name,
address, phone and misc info. I'd like to change this to
be a combo box for the shipper/consignee name only and
have access auto fill-in the address, phone and misc info
into 3 new fields. Any help would be greatly appreciated