How to Display Multi List Box Selection on Report

[S Jackson]

I want my report to display the selections a user has made from a
multi-select list box. I tried inserting this as the control source:

=[Forms]![fdlgRptsSingle]![RegListBx].column(0)

But that only creates wierd results. It puts in the last selection made by
the user, not ALL of the selections.

Can anyone help here?

TIA!

S. Jackson

 

[Van T. Dinh]

It doesn't work this way as *multi-select* ListBox doesn't have a value.

You need to use code to construct the String for your Report. Use the
technique in The Access Web:

http://www.mvps.org/access/forms/frm0007.htm

You probably need to modify the code in the article to suit your needs.

 

[Shelly Jackson]

Okay, I think I understand this. But, I am confused about "where" I do this.
Where do I put this code? I already have code on the "Afterupdate Event" on
the list box. Do I put this code after the If statement I have under the
Afterupdate Event" in the list box control on my form to pass the
concatenated items to the hidden control on the form?

Sorry, I just a lil'bit lost.

S. Jackson

It doesn't work this way as *multi-select* ListBox doesn't have a value.

You need to use code to construct the String for your Report. Use the
technique in The Access Web:

http://www.mvps.org/access/forms/frm0007.htm

You probably need to modify the code in the article to suit your needs.

--
HTH
Van T. Dinh
MVP (Access)

I want my report to display the selections a user has made from a
multi-select list box. I tried inserting this as the control source:

=[Forms]![fdlgRptsSingle]![RegListBx].column(0)

But that only creates wierd results. It puts in the last selection made by
the user, not ALL of the selections.

Can anyone help here?

TIA!

S. Jackson