Display Data from a Combo Box
Combo boxes are one of the most valuable controls you can have on a form, they are so versatile and give you such an extra range of functions for your form that you should really consider understanding how to use them. Also with a combobox as your foundation, you can start to take your first steps into VBA programming!
Display Data from a Combo Box in a Text Box
Display Data from a Combo Box in a Text Box
Video 1 (5:50)
One of the most useful things you can do with a combobox is link it to related data in another table.
Let’s say you have an invoice and you want to choose the customer. You also want to display the customer address. You could link your invoice table to the customer table with a query and use that as the basis for your invoicing form. However it’s much simpler to utilise the customer ID. From the “CustID” you can display all of the customer information you require, customer name, address1. Addr2, Town, etc. Just add a set of unbound text boxes and have them filled with the values from the selected row in the combobox.
It’s an excellent for displaying “Addresses” straight from a Combobox on your form. Makes for a very Tidy interface…
More - ComboBox Info HERE:-
Video 1 (5:50)
… …
Form with Combo Box Lookup
Form with Combo Box Lookup
Video 2 (4:56)
This is another example of how you can set up a Combo Box and have it display information from the combo-box’s row in text-box’s on the form.
Video 2 (4:56)
… …
