Hi, I'm having a bit of trouble selecting an item in a combo box.

I have set the row source, and the list of items and drop down box
function as expected. But I want to know if the user has clicked
something in the list

The click event doesn't respond the first time on item one, only items
two and greater. After that it's ok - but if you want the first item
with the first click - what do you do?

Thanks - Kirk

Set ListIndex to -1 so that nothing is initially selected.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kirkm" wrote in message
...
Hi, I'm having a bit of trouble selecting an item in a combo box.

I have set the row source, and the list of items and drop down box
function as expected. But I want to know if the user has clicked
something in the list

The click event doesn't respond the first time on item one, only items
two and greater. After that it's ok - but if you want the first item
with the first click - what do you do?

Thanks - Kirk

On Thu, 16 Aug 2007 08:13:32 +0100, "Bob Phillips"
wrote:

Set ListIndex to -1 so that nothing is initially selected.

Thanks Bob but I can't try that yet as I have another nasty.

The code is


Private Sub cboFiles_Click()

cboFiles.Visible = False
cboTheYear.Visible = True
cboTheYear.DropDown

End Sub


And the error message is

Run-time error '-2147417848 (80010108)':
Automation error
The object invoked has disconnected from its clients.

Help says something about setting On Error stuff but that's
not helping yet!

Any idea why what that error message is?

Thanks - Kirk

Hi,

Try to use MouseUp event
but it will fire all mouse up action with certain button or all mouse button.
--
Regards,

Halim



"kirkm" wrote:

Hi, I'm having a bit of trouble selecting an item in a combo box.

I have set the row source, and the list of items and drop down box
function as expected. But I want to know if the user has clicked
something in the list

The click event doesn't respond the first time on item one, only items
two and greater. After that it's ok - but if you want the first item
with the first click - what do you do?

Thanks - Kirk