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

Retirving Data for Multiple Select List Box

P: n/a
Hi guys,

i have a multiple select list box on my form, and it saves the selections I
make
into the field just fine.,
but when i open the form on an existing record, it does not show up the
selections that are in the
record already ...

any ideas how to get a multiple select list box to show the selectinos in
the current record ?

thanks,
kevin
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Add a Yes/No field named Selected to the table that is the rowsource of your
listbox. Write code to set Selected in the record that contains your selection
to True each time you make a selection. Base your form on a query that contains
the fields you want and include Selected. Set the criteria for selected to True.

At the appropriate point in what you are doing, you will have to reset all the
Selecteds back to false. You can easily do this with an Update query.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<kr**@dslextreme.com> wrote in message
news:10*************@corp.supernews.com...
Hi guys,

i have a multiple select list box on my form, and it saves the selections I
make
into the field just fine.,
but when i open the form on an existing record, it does not show up the
selections that are in the
record already ...

any ideas how to get a multiple select list box to show the selectinos in
the current record ?

thanks,
kevin

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.