Can I create a Combo Box with two columns that wraps list onto second column?

[dsatele]

I have a form with a combo box the list has 200 employee names on it. I don't want to scroll down the list of names. I would like to have a list of two columns that wrap down one column and then up onto the next column.

Name1 Name6
Name2 Name7
Name3 Name8
Name4 Name9
Name5 Name10

Is this possible?

 

[boblarson]

Welcome to the forum. In answer to your question:

1. No
2. A combo selection is built to select ONE VALUE so how in the world do you think it would distinguish from column 1 or 2?

It can display multiple columns but the value is still only one.

If you set the combo's AUTO EXPAND property to YES, you can just start typing the name in and it will take you to that name in the list, if it exists.

 

[dsatele]

Okay maybe that question was a basic Access question but I'm new to access and I'm amazed I got this far!

Can I ask another dumb question? What is the column count for?
If I set it to three, I get three columns, one with a list of names and the other two are blank. I can't get the list to wrap into the other two columns?

 

[boblarson]

When you set up a combo box, it can use a table, named query, or Select statement as its Row Source. If you include more than one field from any of those sources, you need to set the column count to the number of columns in those or those columns won't be available.

You can show all of the columns in the row source, but only the column that is set in the BOUND COLUMN will give the selection its value. Also, you can display columns from those sources but hide others by setting the column widths property to something like

0";2"

for example if you wanted to hide the Primary Key field but display the text but still have the PK field bound to the table (storing it instead of the text, which is how it should be).

Does that help a bit?

 

[dsatele]

It does - thanks.

Any suggestions - how about a subtable? Can you do a subtable from the same table.

My form is created by tbl_DCR can I create a subtable of tbl_DCR and get just that field entry?