I have two drop down boxes. Both pull from the same table (tblItemMaster). What i need it to do is when the user selects an item from the item dropdown box (ie bolts, screws etc) i need the description box to automatically display that description in the description drop down box. The only part that is working is "lookup" drop down box for parts.
Any help is greatly appreciated!!
Thanks!
1. Change your second dropdown box to a textbox. You don't need another lookup box for description because it is (should be) one of the columns in your first lookup box and just needs to be retrieved.
2. Place the following code in the combobox's AfterUpdate event as shown:
- Private Sub YourCombo_AfterUpdate()
-
-
Me!YourTextbox.Value = Me!YourCombobox.Column(1)
-
-
End Sub
You need to replace the illustrative names (YourTextbox, YourCombobox) I used with the real names in your application. Column indexes start at 0...hence the reference to column(1)...I am assuming the description is in the second column of your combobox Column 1 is the second column.....0,1......