Combo Box autopopulate two fields in Form

[dabears56]

I want my combo box to autopopulate two fields in form. Is that possible?

 

[Linq Adams via AccessMonster.com]

Sure! Set up your combobox using the wizard and include the fields you need,
from Left-to-Right.

If in the Combobox they appear as

Field1 Field2 Field3

then the code would be

Private Sub YourComboBoxName_AfterUpdate()
Me.txtField1 = Me.YourComboBoxName.Column(0)
Me.txtField2 = Me.YourComboBoxName.Column(1)
Me.txtField3= Me.YourComboBoxName.Column(2)
End Sub

Notice that the column index is zero based.