From my table "openshop" I have 4 fields -ospart,osqty,osdate and osdue. I want to create a combo box to look up certain data from the table and put the information into the fields on my form. The ospart in many cases is the same and the other fields are different. I have it working using only the ospart naving a drop down and chosing the ospart but can't get it working for the other 3 fields.
Combo Box
- Thread starter pekuiper
- Start date
RuralGuy
AWF VIP
- Local time
- Today, 06:57
- Joined
- Jul 2, 2005
- Messages
- 13,819
A ComboBox has a Column
property that is zero based so thet Column(1) is actually the 2nd column. You can use the AfterUpdate event of the ComboBox to copy the other columns to a control of your choice with:
Me.OtherControlName = Me.ComboBoxName.Column
...using your control names of course.
property that is zero based so thet Column(1) is actually the 2nd column. You can use the AfterUpdate event of the ComboBox to copy the other columns to a control of your choice with:Me.OtherControlName = Me.ComboBoxName.Column
...using your control names of course.
Similar threads
