I have added two combo boxes to an old, working window. The window has a
bunch of command buttons, which continue to work fine. When I click the
arrow to dropdown the list in the combo box, that works fine, but when I
click on an item nothing happens. It doesn't load into the combo box field.
What might be controlling this? I've never bumped into it before.

TIA
LAS

My column count is 2 and the widths are 0;1. The bound column is 1. I
changed the widths to 1;1 just for diagnostic reasons. It so happens that
columns 1 and 2 contain the same data.

But I should have been clearer. When I click on the list it doesn't close.
It "feels like" I didn't click at all. So it's not as if it's just loading
something that happens not to be visible in the field.

"Arvin Meyer" <(E-Mail Removed)> wrote in message
news:AOudnaDWT5Qs9LLRnZ2dnUVZ_j-(E-Mail Removed)...
> Are you sure that you are displaying the column that you are viewing? By
> that I mean, check the ColumnCount, and make sure that it is greater than
> 1, so that the the visible column is displayed.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.accessmvp.com
> http://www.mvps.org/access
> Co-author: "Access 2010 Solutions", published by Wiley
>
>
> "LAS" <(E-Mail Removed)> wrote in message
> news:i0nl9m$e09$(E-Mail Removed)...
>>I have added two combo boxes to an old, working window. The window has a
>>bunch of command buttons, which continue to work fine. When I click the
>>arrow to dropdown the list in the combo box, that works fine, but when I
>>click on an item nothing happens. It doesn't load into the combo box
>>field. What might be controlling this? I've never bumped into it before.
>>
>> TIA
>> LAS
>>
>
>

I got it. The form was set to NO Data Entry and NO Edit (what's the
difference?)

"LAS" <(E-Mail Removed)> wrote in message
news:i0nl9m$e09$(E-Mail Removed)...
>I have added two combo boxes to an old, working window. The window has a
>bunch of command buttons, which continue to work fine. When I click the
>arrow to dropdown the list in the combo box, that works fine, but when I
>click on an item nothing happens. It doesn't load into the combo box
>field. What might be controlling this? I've never bumped into it before.
>
> TIA
> LAS
>

On Sat, 3 Jul 2010 13:26:06 -0400, "LAS" <(E-Mail Removed)> wrote:

>I got it. The form was set to NO Data Entry and NO Edit (what's the
>difference?)

Data Entry should be NO: if it is Yes, then the form will let you add new
records but it will *not* display any existing records (except those added
during this opening of the form).

Allow Edits should be Yes if you want to be able to edit data in the table,
e.g. by selecting a value from the combo box (and storing that selection in
the table). If it is NO then this will be a read-only form and selecting a
combo box won't change anything.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com