Display Data from a Combo Box in a Text Box

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)

Nifty Access YouTube Thumb Nail
Play Video

… …

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)

Nifty Access YouTube Thumb Nail
Play Video

… …

More Useful Stuff HERE:-

Leave a comment

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.