I'm trying to use a DBCombo box that will change the Bound Text each time
I change the List Field (the default setting for the DBCombo).

However, I should expect that if I select a different item from the combo
box
the Change SHOULD fire but it never does!  WHY NOT!  As a work around, I
had to put my code in the MouseUp event and do it that way... (which does
work).
This is inefficient though, because this will trigger an event each time the
list is clicked on...too many changes are done to the other Data Controls
then!

How does the DBCombo box work?  and Why doesn't it ever show me a Message
box with "Hello World"?

------>

Private Sub dbcFirmType_Change()
    MsgBox ("Hello World")
End Sub

Private Sub dbcFirmType_MouseUp(Button As Integer, Shift As Integer, x As
Single, y As Single)
    If (dbcFirmType.BoundText <> "") Then
        dtaFirm.RecordSource = "SELECT [FirmName], [FirmID] FROM tblFirm
WHERE FirmTypeID = " & dbcFirmType.BoundText & " ORDER BY [FirmName]"
        dtaFirm.Refresh
        dbcFirm.Refresh
    End If
End Sub

Dante

please respond through email.

Thanks.

NEVERMIND!  I read the HELP...

I'll use the CLICK EVENT and check to see if the user
clicked in the dbcAreaList!

Dante

THANKS ANYHOW

If you click on the drop down button and keep the mouse pressed down and
release it over the choice it will say the user clicked on the drop down
button instead of the dbcAreaList..

I had the same problem and I still use the mouse up event :((

Erwin van der Koogh
University of Twente

Please remove "onzin" from above address

On Fri, 20 Feb 1998 21:28:15 GMT, "D. Dante Lorenso"