By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Store List Box values

P: n/a
Store List Box values

I have a form that has hundreds of records in it. The form has a list
box with 10 different options in it. The user is able to select
multiple options from the list box. What I need to figure out is, how
do I store the options the user selected so when they go to the next
record the value isn't lost. Can anyone help?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Jared" <jm*****@hotmail.com> ha scritto nel messaggio
news:96**************************@posting.google.c om...
Store List Box values

I have a form that has hundreds of records in it. The form has a list
box with 10 different options in it. The user is able to select
multiple options from the list box. What I need to figure out is, how
do I store the options the user selected so when they go to the next
record the value isn't lost. Can anyone help?

I think you can use this way:

Property DefaultValue As String
Member of Access.ListBox

So on AfterUpdate ListBox you can set:

Me.lstName.DefaultValue="""" & Me.lstName & """"

Bye.
--
@Alex (Alessandro Baraldi)
---------------------------------------------------------------------------
http://www.mantuanet.it/alessandro.baraldi/
---------------------------------------------------------------------------
Nov 13 '05 #2

P: n/a
jm*****@hotmail.com (Jared) wrote in message news:<96**************************@posting.google. com>...
Store List Box values

I have a form that has hundreds of records in it. The form has a list
box with 10 different options in it. The user is able to select
multiple options from the list box. What I need to figure out is, how
do I store the options the user selected so when they go to the next
record the value isn't lost. Can anyone help?

Loop through the ItemsSelected collection and write them somewhere
before doing anything else?

There's code here to grab the contents of the ItemsSelected
collection:
http://www.mvps.org/access/forms/frm0007.htm
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.