Lists Questions

  • Thread starter Douglas @ Helpdesk
  • Start date
D

Douglas @ Helpdesk

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?
 
K

Klatuu

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.
 
Top