That's one method. The other would be to include the info in the Combobox and then assign it in the AfterUpdate event. To do this you'd simply
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
the code would be
Code:
Private Sub YourComboBox_AfterUpdate()
Me.txtField1 = Me.YourComboBox.Column(0)
Me.txtField2 = Me.YourComboBox.Column(1)
Me.txtField3= Me.YourComboBox.Column(2)
End Sub
Notice that the column index is Zero-based.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007