Display Multiple Fields in a Closed Combo Box in Microsoft Access

In this Fast Tips video, I'll show you how to display multiple fields in your Microsoft Access combo boxes, even when the box is closed. You can use String Concatenation or DLookup.

LEARN MORE:

LINKS

COURSES:

ADDITIONAL RESOURCES:

KEYWORDS
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, multiple fields, combo box, closed combo box, display multiple fields, first name, last name

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[Jojosmith]

Richard is the funniest teacher on the planet earth. Thank you so much for sharing your power

[zezeandjr]

Very refreshing, and as usual, all your tutorial vids are top quality.

[artistryartistry]

Hi there, do you have a video that explains about bound columns? I'm having so much trouble with this concept. Thank you!

[cambodeeritnews]

hi, instructor. can we put image in listbox control of ms access?

[HaniAbusido]

hi, am happy with your channel and its very fantastic, i have small issue with combobox

I have a subform (continuous form or the DataSheet form ) and it contains 2 Comboboxes, the second depends on the first in the filter or shows the data,



For example :
I have category of "Flowers or Coffee" and each category has its own Items .

I made two combo boxes, and did the necessary linking them, and when I chose the category and went to the second box, it actually showed me its items, so far things are good and working comfortably.



But the problem is when adding another category on the second line to, the first item that was previously selected disappears.

What is the easy solution to avoid this problem.

[markbiboso]

Sir, How to create a Pre-Filled List of Products/Items For Orders in an Order Form. I hope you can help me with this inquiry. Thanks so much.

[accountsdepartment]

Hi, I want to combine multiple row data into one row by comma separated based on ID field, is it possible or not in MS Access.

[ahmedbucheery]

I have a query that I can search by any data while I am typing it, using function (Like), it was working well, but when I changed my combo boxes to this style explained in your video I cannot use this query any more! I tried to solve it but failed!

[ehteshamshah]

How to create selectable check box type combo box

[andriyos_]

I have three tables. Field from the first table are linked to the second table, and field from the second table are linked to the third. 1 > 2 > 3. If I select multiple fields in the third table from the second, it shows numbers and not text. how to fix it? I think I explained logically)))