470,638 Members | 1,579 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

Ghosts in Multiselect listbox

1
I've got a form that uses a multiselect listbox. When a user is selected from a combo box, values are populated into this listbox associated with that user.

The problem is, if one person has say 10 entries in the listbox, and selects the last 3-4, and the next user only has 2 entries, those last 3-4 rows are still highlighted in the listbox. This introduces null values into my code which is definitely not good.

I've tried using beforeupdate and onclick events for the combo box - but they don't seem to execute at the right time (before the new information is loaded). Does anyone have any ideas for me?

(No, Exorcisms are not an option)

Thanks :)
Jan 16 '07 #1
2 1456
MMcCarthy
14,534 Expert Mod 8TB
I've got a form that uses a multiselect listbox. When a user is selected from a combo box, values are populated into this listbox associated with that user.

The problem is, if one person has say 10 entries in the listbox, and selects the last 3-4, and the next user only has 2 entries, those last 3-4 rows are still highlighted in the listbox. This introduces null values into my code which is definitely not good.

I've tried using beforeupdate and onclick events for the combo box - but they don't seem to execute at the right time (before the new information is loaded). Does anyone have any ideas for me?

(No, Exorcisms are not an option)

Thanks :)
In the Before Update of the Combobox try putting Me.refresh.
Jan 16 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
If that doesn't work put it before the code that requeries the listbox which I assume is in the comboboxes after upate event.

Mary
Jan 16 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by arthur-e | last post: by
2 posts views Thread by Sally | last post: by
2 posts views Thread by Cassie Pennington | last post: by
6 posts views Thread by Ņ Mahesh Kumar | last post: by
2 posts views Thread by Steph | last post: by
3 posts views Thread by kaosyeti via AccessMonster.com | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.