Multi-Select Listbox, ClearAll, and AfterUpdate

  • Thread starter Thread starter croy
  • Start date Start date
C

croy

On a form used for launching a report, a multi-select
listbox is used like a filter, limiting the results that go
to the report. The AfterUpdate property for the listbox has
code to make some command buttons on the form enabled, and
some not enabled. This all works very nicely.

Near the listbox, I placed a couple of command buttons to
make it easier for the user to "select all" or "clear all",
and that works also (thanks to Allen Browne for that code).

The problem I've having is that using the "ClearAll" button
doesn't seem to cause the AfterUpdate event for the listbox
to fire, resulting in those other command buttons to remain
enabled or disabled, when I want that status to change
because of the "ClearAll" command.

Would anyone care to offer a way to get the AfterUpdate
event to fire when using the ClearAll code?
 
Simply call the AfterUpdate event from your ClearAll event's code:

Private Sub ClearAll_Click()

' existing code here...

Call MyListbox_AfterUpdate

End Sub
 
Simply call the AfterUpdate event from your ClearAll event's code:

Private Sub ClearAll_Click()

' existing code here...

Call MyListbox_AfterUpdate

End Sub
Click to expand...


Perfect! Thanks Douglas.
 
Back
Top