combo box error

[andyk]

Hi,
I have a combo box that seems to fire it's error handler on
every kind of event: click, change, etc.
I thought there might be something corrupt, so I created a
new db with a single form, and a single value "A" in a
value list, and I still get the error handler fining.

What is it that causes an error on a simple click event?
Am I totally missing something about combo boxes?
Any comments to enlighten me greatly appreciated.
Andy


below is simple code for event:

Private Sub Combo0_Click()

On Error GoTo Err_Combo0_Click

MsgBox "hi"

Exit_Combo0_Click:
MsgBox "exit click event"
Exit Sub

Err_Combo0_Click:
MsgBox "err click " & Err.Number & Err.Description
Resume Exit_Combo0_Click


End Sub

 

[Mark]

Since your error handler displays the error number and description, is it
always displaying the same error number? What's the error? If we new what
error was occurring, perhaps we could offer a solution.

 

[andyk]

Hi Mark,
That's the really strange part, it goes directly to the
exit MsgBox "exit click event", so I don't get an err num
or description.
I did put an error.number and error.description in the exit
part, but the msgbox was blank...
I added a list box and the same thing happens, it seems to
fire on a change, click, etc. event.
Using acc97 sr2, if that helps.
My app runs fine, no crashes, other errors etc, but I'm
really interested to know why a combo and list fires an
error, on an event?
Thanks
Andy