Combo box problem not fixed by hotfix

[aardvick]

Seems like my problem should have been fixed by the hotfix for Office2003
SP3, but not so for me : (
Row source for my combo box is a query from a single table. There are 7
columns, but only the first 2 columns are visible (width > 0"). The bound
column property is set to 2. But that's where the problem lies. It doesn't
matter WHAT number I enter for the bound column property - what I get is the
column 1 value everytime.
Please tell me I'm overlooking something simple?
Or maybe installed the hotfix incorrectly? Sounds like it works for
everyone else...
TIA,
-Vicki

 

[Douglas J. Steele]

Have you declared the ColumnCount property correctly?

 

[aardvick]

I think so... I have column count = 7 and bound column = 2.

 

[aardvick]

I forgot to mention that my row source query has 7 columns because I'm using
those other values to populate fields on my form. THAT part is working out
fine.

e.g. Me.txt_Species.value = Me.cbo_StudyNo.Column(3)

The problem is specifically that the combo box first displays nothing at all
(even thought there IS a value in that field) and then when I select a value
from the drop-down list, it displays the value from the wrong column (always
column 1 no matter what I set the bound column value to).

Frustrating! And I thought the hotfix was supposed to address this very
issue! For now I'm just going to rewrite my query to put the value I want
bound in the first column. I'll let you know how that works...

 

[Douglas J. Steele]

As far as I'm aware, the hotfix addresses the issue that nothing would
display in the drop-down list (although it would be apparently that there
was data associated with it). I've never heard of an issue associated with
the wrong value being displayed or selected.

 

[John Spencer]

A combobox always displays the FIRST VISIBLE column when the combobox does not
have the focus. It always has for me. The bound column does NOT change which
column is the first visible column.

If you want the bound column to display, then make it the first column.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[aardvick]

Ahhh... That's what I was missing.
In that case the hotfix DID fix my combo box problems.
I just had additional *brain* problems that needed fixing : )
Thanks John!
-Vicki