Populating more than one field from a combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Back
Top