Troubleshoot list boxes, drop-down list boxes, and combo boxes

I don't understand how list boxes work. Please give me an overview.

I don't understand how combo boxes and drop-down list boxes work. Please give me an overview.

The list box, drop-down list box, or combo box isn't sorted the way I want.

The text displayed in the combo box is from the wrong column. How do I display data from another column?

When I select a value in a list, it disappears or gives me a message.

I can't select a value in the list box, drop-down list box, or combo box.

#Error? appears in the combo box or drop-down list box, or the combo box or drop-down list box is blank.

I want to refer to a column in the list box or combo box other than the bound column.

I can't type a new value in the combo box.

Why isn't a value that I type in the combo box added to the list?

My list box, drop-down list box, or combo box runs too slow. What can I do to speed it up?