Multiple Values From Dropdown List
Second Field From Lookup List/Drop Down List Box
Let’s expand a previous example drop down list example and suppose that we have account numbers associated with each shipping method and that these account numbers (for whatever reason) can change over time.Therefore we want to capture the current account number in the widget shipping record. Here is how the combo box looks in operation:
Now I bet you want to know how I got the account number to jump from the drop down list over to the account field. New! Download Access example of Filling Data Fields From Combo Box.
It is fairly easy – add an Event Procedure to the After Update event trigger of the combo box. Here are the lines of code that go into the procedure:
Need help getting multiple values from a combo box? Give us a call and we will solve the problem or there is no charge! $100 1/2 hour.
The only line that you actually have to type is the one starting with Me… Note that Column(2) contains the account number in the combo box. Combo boxes start counting fields at zero. The actual fields are: Shipping_Method_ID; Shipping_Method; Account.
Don’t miss our tutorial downloads for additional help with combo boxes.
Microsoft Office VBA, MS Access 2003, 2007, 2010, 2013, 2016