Listbox fails to update after deleting an item

[skysurfer]

Hi,

I've created a nifty userform listbox prototype that I'm about to use on a project and it's nearly complete except for 3 related bugs I need your help on.

The first is the macro that deletes an item from the listbox and the underlying database (cmdDelete) causes the Listbox1_Click macro--and the userform--to blow up. cmdDelete completes successfully, but I'm guessing the Listbox macro is triggered and is looking for the deleted item and crashes the userform??? Which is tied to the second bug...

I can't get the listbox to update after a record has been added or deleted so that the user can then continue manipulating the listbox items.

And the last bug is that when the userform launches, I can't get the initialization to highlight that last record (item) clicked on (which is stored in cell A10).

Lawrence

[royUK]

You can't use RemoveItem unless the ListBox has been loaded using AddItem. Try

Please Login or Register  to view this content.

[skysurfer]

Hi Roy,

Your code successfully deletes the record in the database and the listbox, but it triggers the Listbox1_Click macro and then crashes on this line:

Please Login or Register  to view this content.

Attached an updated file your your code.

Thanks!

Lawrence

[skysurfer]

Perhaps the initialize macro needs to refresh the listbox range???

Lawrence

[skysurfer]

Solution code:

Please Login or Register  to view this content.