I have a simple form with a listbox and a command button. When I enter data
into the listbox and press the command button, the Listbox_AfterUpdate event
fires twice and erratically. If I step thru the code, it fires once and when
it should fire. I think this is a bug in XL97 because a few people from the
LISTSERV's are reporting the same problem.

Can someone verify that there is a bug and why?

Here is my code:

Private Sub cmbClr()
    For Each MyControl In Controls
        If (MyControl.Name Like "tb*") Then
            MyControl.Value = ""
        End If
    Next MyControl
End Sub

Private Sub cmbOK_Click()
    Call cmbClr

' If you comment out the following line,
' or place a breakpoint here-
' it works perfectly
    tbOrderNum.SetFocus
End Sub

Private Sub tbOrderNum_AfterUpdate()
MsgBox "Updating DataSaved to FASLE!"
End Sub

--

Julian Milano
IT Supervisor
Viviannes Collection