Connecting Tech Pros Worldwide Forums | Help | Site Map

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

Jillian Cee
Guest
 
Posts: n/a
#1: Nov 13 '05

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
Guest
 
Posts: n/a
#2: Nov 13 '05

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


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" <champagneharley@msn.com> wrote in message
news:4188ffcc$0$14477$c397aba@news.newsgroups.ws.. .[color=blue]
>
> 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[/color]


Closed Thread


Similar Microsoft Access / VBA bytes