Populating more than one field from a combo box

C

CT

Combo boxes are new to me. I created a combo box using the Wizard from a
query that has 4 fields per row. One field in my form is being populated
from the row selected, which is correct. However, 2 other fields in the form
should be populated from the same row selection.

How do I specify which fields should be linked from my combo box into my form?

Please help!
 
D

Douglas J. Steele

In the AfterUpdate event, put code like:

Me.Text1 = Me.Combo1.Column(1)
Me.Text2 = Me.Combo1.Column(2)

Note that the Column collection starts at 0: what I'm doing above is moving
the content of the 2nd column of the selected entry to Text1, and the
content of the 3rd column of the selected entry to Text2.
 
Top