|
Quick Tip Details |
Question:
Automatically Fill controls based on users selection from a combobox or listbox. |
Answer:
Ensure the additional fields are savable in the combobox/listbox. The can be hidden by setting the column width to 0 for the appropriate column if desired. On the After Update event of the combobox/listbox, use the column property to retrieve the desired value (the first column is 0 – not 1). |
Code:Private Sub YourCombobox_AfterUpdate()
Me.[Your Textbox 1] = Me.YourCombobox.Column(1)
Me.[Your Textbox 2] = Me.YourCombobox.Column(2)
End Sub |
|
