Set up your Combobox using the Wizard and include the Fields you need, from Left-to-Right.
If, in the Combobox, they appear as
Sirname Firstname Firm
the code (substituting your actual Control names, of course) would be
The txtSirname, txtFirstname and txtFirm Controls have to be Bound to Fields in the underlying Table/Query.
Private Sub YourComboBox_AfterUpdate()
Me.txtSirname = Me.YourComboBox.Column(0)
Me.txtFirstname = Me.YourComboBox.Column(1)
Me.txtFirm = Me.YourComboBox.Column(2)
Notice that the column index is Zero-based, i.e. the first column is referred to as Column(0), the second as Column(1) and so forth .
Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007