Simple Combobox

[jhess85]

I would like to create a combobox where a user can select from a list of
unique values that are within a table.

I created this using the wizard with the following values:
Row Source Type: Table/Query
Row Source: SELECT [ITL].[ID], [ITL].[Transaction Name] FROM [ITL] ORDER BY
[Transaction Name];
Column Count: 2
Bound Column: 1

All the values in the drop down are blank when using the combo box. When a
value is selected the value does display in the collapsed combo box. How do
I get the values to display in the drop down correctly? The purpose of this
combo box is to allow for a user to select a value and then I will pass this
value into a filter.

 

[Jim Bunton]

1. Does the query by itself return a set in which all rows are definitely
non blank? run the query and reoder the rows with A:Z the Z:A on both
columns to check this.

2. If it's [ITL].[Transaction Name] that you want to display then
? are the transaction Names truely unique?

3. look at column widths for the combo and set the first one to 0 if you
actually want to see just the content of the second column

Jim Bunton