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

Multiple Selections in a report

P: n/a
I am relativly new to access 2000 and am having some trouble with a
report. I am not sure what I want to do is something I can do in
access. I want to be able to choose from a combo box multiple
selections in a form and from those selections present them in a
report. For example select a selection A,B, and C out of 9 possible
choices. Then show them seperated by a comma in a field in the report.
I also want the option of only selecting one selection if needed. Is
code needed or is there another method I should try.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You need to use a multu-select list box. Look in the Help file for its
properties. Then you need to use code to count the number of selections and
then loop that number of times to create a string of your selections
separated by commas.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Craig B." <as********@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
I am relativly new to access 2000 and am having some trouble with a
report. I am not sure what I want to do is something I can do in
access. I want to be able to choose from a combo box multiple
selections in a form and from those selections present them in a
report. For example select a selection A,B, and C out of 9 possible
choices. Then show them seperated by a comma in a field in the report.
I also want the option of only selecting one selection if needed. Is
code needed or is there another method I should try.

Nov 13 '05 #2

P: n/a
Craig B. wrote:
I am relativly new to access 2000 and am having some trouble with a
report. I am not sure what I want to do is something I can do in
access. I want to be able to choose from a combo box multiple
selections in a form and from those selections present them in a
report. For example select a selection A,B, and C out of 9 possible
choices. Then show them seperated by a comma in a field in the report.
I also want the option of only selecting one selection if needed. Is
code needed or is there another method I should try.


Use a ListBox instead of a ComboBox. Set the ListBox's MultiSelect
property to Simple or Extended. Use VBA in the report's Open event to
retrieve the selected items (ListBox's ItemsSelected collection) and do
w/ them whatever you want to.

Read the Access Help articles on ListBoxes and the Report's OnOpen event.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.