AfterUpdate Listbox.ItemsSelected works but not Form_Load Listbox.ItemsSelected

[Nothnless]

I Have 2 ListBoxes, Listbox1 has Row Source from a table but Listbox2's Row Source depends upon what is selected in Listbox1. Everything works fine as expected using AfterUpdate for Listbox1 event. However, once I leave the form and come back Listbox1 still has it's selections but Listbox2 is now blank. I want to keep what was in Listbox2 since Listbox1 still has selections.

 

[Micron]

The title of your post is the only clue I get from what you posted. You cannot deal with listbox selections in the form Load event. That event only happens after the form opens and only once until closed then opened again. However, I don't see how that fits in with selecting a different form then coming back to this one that is still open, yes? Not clear what "leave the form" means, but I take it to mean it loses the focus, not that you closed it. If you're not closing the form lstbox2 row values should remain unless subsequent code is doing something to them. How are you populating lstbox2 rows - value list from lstbox1 itemsSelected?

 

[Nothnless]

Hi, no I am actually closing the form and then coming back to it. So I guess I just shouldn't close the form, I can just hide it instead. Okay that's an easy solution for my purposes however the underlining issue that confused me was as to why Access no longer recognizes the ListBox Items when reopened. If I close the form and open it back up ListBox1 still has it's previously selected items. I guess this is just because its bound to a table.

 

[Micron]

Unbound controls cannot hold their values when the form is closed so yes, you have figured out the cause. The one exception would be if the control source property is set to something that is either static or is the result of an expression; e.g. = 5 or = 5*2. Such an expression could not depend on other unbound/missing values.