By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,920 Members | 1,767 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,920 IT Pros & Developers. It's quick & easy.

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

P: n/a

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
Share this Question
Share on Google+
1 Reply


P: n/a
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.