Here's a Step-by-step
- Set up Textboxes on your Form, for all items, each one bound to the appropriate Field in the Form's underlying Table
- Place a Combobox on your form. When the wizard comes up
- Select "I want Combobox to look up values in a table/query"
- Select your Parts Table
- Click and move each Field to the right hand box
- Sort by DollName
- Select "Remember Value for Later Use"
- Chose a Caption for the Label of the Combobox (if desired)
- Click on Finish
Assuming that the items were added in the order of DollName, Head, Body, RightArm and LeftArm, in the AfterUpdate event for your Combobox
Code:
Private Sub YourComboBox_AfterUpdate()
Me.DollName= Me.YourComboBox.Column(0)
Me.Head = Me.YourComboBox.Column(1)
Me.Body = Me.YourComboBox.Column(2)
Me.RightArm = Me.YourComboBox.Column(3)
Me.LeftArm = Me.YourComboBox.Column(4)
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