Multiple Selections in a report

[Craig B.]

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.

[PC Datasheet]

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.

[MGFoster]

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)