Passing list box selection from 1 form to another

[johnseito]

Hello,



So I created two list box in a form. It allows users to select two items from two separate list box and then they click on a button after the selection and it goes to another form.

I want the other form to use the items selected from the first form. How do I pass these variables or items to the second form ?

Please advise !

[Micron]

depends.
Is the first form still open? You can reference the selecteditems property from each listbox in the 2nd form's code. This would be the easiest.
Not open? pass the items as comma separated values in a string by using the OpenArgs parameter of the Docmd.OpenForm method. Now you have to separate them in the code of the second form - not so easy for you.

[johnseito]

Thanks Micron, I have done it the OpenArgs way even with the previous form still open. But is limited in the number of variables it can carry over.

The 1st form is still open.
I will do it with the selected item method, which is forms.form.list.column.

Thanks for your advise and suggestion.

[Micron]

But is limited in the number of variables it can carry over.

For multiple items, you'd use a variable. The maximum character length for a string variable is huge, although it might be limited in certain ways of using it.