combo box question

[lmcc007]

Is there a way to choose a number but display the text? That is, we have over a thousand records to enter; therefore, it would be easier for them to choose 1, 2, 3, 4 and so on instead of having to type the first few letters from a list, hit the down arrow and choose the correct one. The lookup table is as follows:

tlkpEventTypes
EventTypeID...........EventType
1..........................Authorization -- general
2..........................Authorization -- credit and criminal background check
3..........................Authorization -- medical
4..........................Authorization -- tax​

and so on.

 

[John Big Booty]

One way would be to have a text box bound to the same control as the Combo, now assuming that the event type ID is the bound column of the combo the user could select from the combo or simply type the number directly into the text box.

 

[lmcc007]

One way would be to have a text box bound to the same control as the Combo, now assuming that the event type ID is the bound column of the combo the user could select from the combo or simply type the number directly into the text box.

Okay. Create a txtbox and the number I enter in the text box will equal to the combo box. Thanks!

 

[The_Doc_Man]

There is nothing wrong with having a combo box show you multiple columns, either.

If the first column is the bound column and the second column is text, and if you don't make the first column have zero width, you can select the row from the number in the first column (since it will be visible) but still see the second column.

 

[lmcc007]

There is nothing wrong with having a combo box show you multiple columns, either.

If the first column is the bound column and the second column is text, and if you don't make the first column have zero width, you can select the row from the number in the first column (since it will be visible) but still see the second column.

But, I want the text to be displayed not the number.