Access multiselect list box - transfer results to a query ... HOW????

[Jillian Cee]

I have a multiselect list box (simple). I need to find out how to get
Access to recognise my multiple selections firstly (I believe) then I
want these selections to go into a query so that I can print a report
based on these multiple selections from my list box.
I am not very good at coding, and want to advoid it if possible.
Many thanx.
Regards,
Jillian
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Allen Browne]

A query cannot directly use a multi-select list box.

Since you want to use the list box to filter your report, copy the code from
this article:
Use a multi-select list box to filter a report
at:
http://members.iinet.net.au/~allenbrowne/ser-50.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jillian Cee" <ch*************@msn.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

I have a multiselect list box (simple). I need to find out how to get
Access to recognise my multiple selections firstly (I believe) then I
want these selections to go into a query so that I can print a report
based on these multiple selections from my list box.
I am not very good at coding, and want to advoid it if possible.
Many thanx.
Regards,
Jillian