Lists Questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Douglas @ Helpdesk - 06 Dec 2007 21:37 GMT

i have a list that i have 10 different accounts listed in on my form.
I have it setup so that i can select multiple options.

how do i get this list to show up in the actual table? I had to create this
list on the form itself.

is there a way to take that list that i made and convert it into a text
field when i run a report? and have it display what was selected?

Reply to this Message

Klatuu - 06 Dec 2007 22:48 GMT

Are you trying to put multiple accounts in the same table field?
That doesn't seem right.

A multi select list box will not return a value if you use it like

Me.txtAccount = Me.lstAccountList

You have to loop through the ItemsSelected collection of the list box to
return one value at a time. Look in VBA Help for ItemsSelected. It has a
good example of how to use it.

Signature

Dave Hargis, Microsoft Access MVP

> i have a list that i have 10 different accounts listed in on my form.
> I have it setup so that i can select multiple options.
[quoted text clipped - 4 lines]
> is there a way to take that list that i made and convert it into a text
> field when i run a report? and have it display what was selected?

Reply to this Message