I have a form that includes a field for the operating system of the client. I want this to be populated from a look-up table. I want the combo box to display the text name of the OS but enter the numerical ID number to the client table. How do I do this?
Combo boxes - values and titles
- Thread starter AvalonMel
- Start date
Fear Naught
Kevin
- Local time
- Today, 21:40
- Joined
- Mar 2, 2006
- Messages
- 229
Setup the correct relationships between the client table and the lookup table. Use the wizard to create the Combo Box and voila it will work!
HTH
HTH
- Local time
- Today, 21:40
- Joined
- Sep 12, 2006
- Messages
- 16,075
when you select the columns in a combo box wizard, select the numeric code as the first column, and the text description as the second. Make the width of the first column zero. (the wizard recommends this)
the combo box then stores the value of the first (hidden) column, but displays the value in the second (non-zero width) column, which is what you want.
access actually displays the data taken from the first non-zero width column.
the combo box then stores the value of the first (hidden) column, but displays the value in the second (non-zero width) column, which is what you want.
access actually displays the data taken from the first non-zero width column.
boblarson
Smeghead
- Local time
- Today, 13:40
- Joined
- Jan 12, 2001
- Messages
- 32,040
And just for additional learning information -
You can set the rowsource to the combo box easily by clicking the elipsis next to rowsource in the properties dialog. You can then, in the properties window as well, set the number of columns to be included (if you set the query but don't set the number of columns, the default is 1) and then the width of the columns. Setting the width is where you can have a column included in the combo box (and listbox) but not show it. So, if you set the key to not show by using 0" in the width and then set the BOUND COLUMN to be that column (it can be something other than the first column, but traditionally you set your query to have the key as the first column).
---and Gemma beat me to it as I took too long to type ----
You can set the rowsource to the combo box easily by clicking the elipsis next to rowsource in the properties dialog. You can then, in the properties window as well, set the number of columns to be included (if you set the query but don't set the number of columns, the default is 1) and then the width of the columns. Setting the width is where you can have a column included in the combo box (and listbox) but not show it. So, if you set the key to not show by using 0" in the width and then set the BOUND COLUMN to be that column (it can be something other than the first column, but traditionally you set your query to have the key as the first column).
---and Gemma beat me to it as I took too long to type ----
Similar threads
