Cannot Get ListBox .ItemsSelected, help!

[johnywhy]

Help.

i am unable to retrieve .ItemsSelected of a multiselect listbox on a form.

1. the form is visible, and i manually select some items in the listbox.
2. then in vba i get the .ItemsSelected.Count property of the listbox.
3. ItemsSelected.Count is 0. This is a bug?
4. i can see items selected in the listbox.

What's the problem?

More info:
i am loading several forms in Hidden mode.
then i make only one form visible at a time by vba.

if i open this one form by itself, with no other forms loaded, then i am able to retrieve .ItemsSelected.Count value correctly.

also posted to http://www.utteraccess.com/forum/Lis...-t2008662.html

[June7]

Post the exact code you are using or provide db for analysis. The code is located where?

[johnywhy]

Post the exact code you are using or provide db for analysis. The code is located where?

never mind, i found my answer elsewhere.
ps, how come i cannot see my OP?

thx

[pbaldy]

never mind, i found my answer elsewhere.
ps, how come i cannot see my OP?

thx

You should see it now. I thought I approved it earlier but must have goofed up. It may help others if you post your solution here.

[johnywhy]

SOLVED:


thorough explanation here:


social.msdn.microsoft.com/Forums/office/en-US/cb59d18f-3214-4fe5-bdc8-bf40c99fb483/cannot-get-listbox-itemsselected-help?prof=required


"If the form isn't loaded when you make this reference to its class module, Access will load a hidden copy of the form and add it to the Forms collection."


"remove all uses of Form_<form name> and replace them with the canonical usage:


'DoCmd.OpenForm "FormName"' instead of 'Form_FormName.Visible = True'
'Forms!FormName.ControlName' or 'Forms("FormName").ControlName' instead of Form_FormName.ControlName
'DoCmd.SelectObject "FormName"' instead of Form_FormName.SetFocus