View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TDW TDW is offline
external usenet poster
 
Posts: 18
Default Listbox not refreshing on update

Hi There,

I have a form with a multicolumn listbox and text boxes corresponding to the
columns of the listbox. I also have 'Insert', 'Update' & 'Delete' buttons
that are used to maintain the list in conjunction with the textboxes. I am
using the listbox_Change event to keep the textboxes and listbox synchronized.

My issue is this: when I insert new items into the listbox it doesn't always
display the list correctly. Suppose the list currently has "Item1, ...,
Item5, Item7". I will insert 'Item6', the listboxes will display Item6 but
the list will show two of Item7. If I scroll through the items in the
listbox, it will correctly display the list items in the textboxes; but, the
listbox will continue to show two of Item7. If I continue to scroll up and
down through the list, the listbox will eventually 'refresh'(?) and start to
show the correct list.

What gets me is that internally the list is clearly OK as scrolling through
the list always generates the correct values being displayed in the
textboxes. It's as if the listbox control needs some time before the
'displayed' list matches the 'internal' list.

Any thoughts, suggestions would be greatly appreciated!
Thanks,
tdw

--
Timothy White
Contract Programmer
Ontario, Canada

<my initialshite<atsympatico<dot<countryCode