Multiple choice in list box

[Guest]

Hi everyone

I am trying to display a report where the user can choose multiple criteria
from a list on the reports switchboard.

So far I have managed to write the criteria in the report's query to look up
a certain combo box choice (of crop type) on the reports form. For example
the following criteria is in the Crops column in the query. [Forms]![frm
Reports]![cmbCrop]

The combo box is a list that is ever changing so comes from a query listing
the different crops so that as new ones get added, they appear in the list.

How do allow the user to choose more than 1 crop? Neither a combo box nor a
list box allows more than one choice?

All help most gratefully received Ah yes, I am using version 2000 which
may be upgraded to 2003 soon (I hope) and I am useless at VB.

 

[Allen Browne]

See:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

 

[Guest]

Thank you Allen for answering me. I printed your page yesterday and am still
struggling with it I'm afraid. VB leaves me cold and completely at sea
sadly.
Is there any way of doing this in a macro do you think?

See:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am trying to display a report where the user can choose multiple
criteria
from a list on the reports switchboard.

So far I have managed to write the criteria in the report's query to look
up
a certain combo box choice (of crop type) on the reports form. For
example
the following criteria is in the Crops column in the query. [Forms]![frm
Reports]![cmbCrop]

The combo box is a list that is ever changing so comes from a query
listing
the different crops so that as new ones get added, they appear in the
list.

How do allow the user to choose more than 1 crop? Neither a combo box nor
a
list box allows more than one choice?

All help most gratefully received Ah yes, I am using version 2000 which
may be upgraded to 2003 soon (I hope) and I am useless at VB.

 

[Guest]

Good heavens, it worked. Thank you. Now I just have to transfer the whole
lot to the Access 2000 version at work tomorrow.

If I leave there (and I may) I will write a note to add the text box to the
report header section for whoever comes after me.

Thanks a lot, I just wish there was an easier way of doing this though
without having to enter the code

See:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am trying to display a report where the user can choose multiple
criteria
from a list on the reports switchboard.

So far I have managed to write the criteria in the report's query to look
up
a certain combo box choice (of crop type) on the reports form. For
example
the following criteria is in the Crops column in the query. [Forms]![frm
Reports]![cmbCrop]

The combo box is a list that is ever changing so comes from a query
listing
the different crops so that as new ones get added, they appear in the
list.

How do allow the user to choose more than 1 crop? Neither a combo box nor
a
list box allows more than one choice?

All help most gratefully received Ah yes, I am using version 2000 which
may be upgraded to 2003 soon (I hope) and I am useless at VB.