List Box Values

[Guest]

Here is one that has me stumped:

On a form, I am trying to populate one textbox with the bound column of a
list box, as the user moves through the values (easy enough) and poplulate a
SECOND textbox with the value from the second column.

I have placed the code on 'after update'

When the user scrolls through the values in the list box, the firts textbox
(bound column) updates with the new value, fine.

But it popluates the second column with the previous value (whatever the
user is moving off of). For this I am using the .ItemsSelected property
(retrieving the number placement in the listbox) and then the .ItemData
property to retrieve the value.

Has anyone encountered this before.

Thanks,

DEI

 

[Wayne Morgan]

Yes, I've seen similar results before. Is this a multiselect listbox? If so,
try setting it to Simple instead of Extended and see if the problem goes
away. Also, if this is a multiselect, how are you placing the data from
multiple rows in the textboxes? If it's not multiselect, then you don't need
to use ItemsSelected and ItemData, instead just use the Value and Column
properties.