470,620 Members | 1,399 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,620 developers. It's quick & easy.

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


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!
Nov 13 '05 #1
1 8451
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Sean C. | last post: by
2 posts views Thread by Cassie Pennington | last post: by
3 posts views Thread by krygsma | last post: by
1 post views Thread by tod4 | last post: by
4 posts views Thread by cameron | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.