combobox displaying oddly after update

[markjkubicki]

I have a combobox with a column count of (6), and column widths: 0";0.25";6";0";0";0"; the bound column is 3



Initally, and when pulled down, it displays correctly (1 narrow .25" column, and 1 wider column: 6"); however, once a value is selected, and an After Update event fires, and the combobox displays only the value of column 2, flush right in a single 6.25" wide column (!?) When you subsequently pull down, it again displays correctly, but then leaves only the value of column 2 in a single column (just as previous)

Perplexed, but with many thanks in advance,
Mark

[June7]

Is this a bound combobox? Why have the hidden column if that is not the value saved? It is unusual to bind combobox to other than the first column.

Post code.

[markjkubicki]

it is unbound, and the concealed columns are used to filter the datasource

[CJ_London]

multiple columns are only visible in the dropdown. Once a selection is made, only the first visible column can be seen. Have one or more unbound text boxes with a controlsource something like

=mycombo.column(3) to display what is in that column once a selection is made

[CJ_London]

concealed columns are used to filter the datasource

if they are not required to be displayed then in the query grid, untick the 'show' box

[June7]

Fields that have no filter parameters and are unchecked will be dropped from the query design grid. If a field is needed in the combobox RowSource, it must be check in the grid.

As Ajax notes, the dropdown list shows all fields for columns with a width greater than 0 but the box part shows only the BoundColumn value.

[markjkubicki]

since the combo box initially does display both columns, and once the code has run, I don't need to save nor see the choice, I wonder if I could run a cancel event kind of thing at the end of the code to clear the result, and onec again see all of the columns as initially?

[CJ_London]

you can only see all the columns in the drop down and you can only see the dropdown when it has the focus. The accepted solution when you want to still be able to see the values of the other columns is as per post#4

[June7]

If you are saying the dropdown list does not display all columns, that is odd. Why would code cause that? Why would the hidden columns be needed for filtering? If the combobox RowSource includes an ID primary key which is the foreign key in records to be searched, just use the ID for filtering.

Provide images and the code or the database for analysis.