>I am just learning to use multi-column and single column combo boxes and I have a couple questions.
>
>First, are there any decent DETAILED tutorials for using combo boxes either on the net or in print.
Have you checked our Knowledgebase and FAQs? Also Microsoft's KB? Just keep trying things, and ask questions whenever you want :-)
>Second, If my data is in the form; column1, column2, column3 and I want to display only column2 in the combo box and I want to return the value in column1 how do I set this up?
You may have already found the ColumnCount property to show how many columns are displayed. However, you can also set the WIDTH of a column to 0. For 4 columns, ColumnCount = 4, ColumnWidth = 0,100,0,150 This will show columns 2 and 4 on the screen when the combo box is active.
However, the data in column 1 is always the data that will show when the combo box is closed. Usually you put the column you want the user to see in column 1 (this is the 'display value'), add any other columns the user needs to see in the next columns and finally, in the last column put the value that will be stored in the table using the combobox. This column will be the bound column, and it does NOT have to be visible.
>Thanks, RB
You're welcome,
HTH
Barbara