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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jillian Cee - 03 Nov 2004 16:57 GMT

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

Reply to this Message

Allen Browne - 03 Nov 2004 17:20 GMT

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

Signature

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.

> 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
[quoted text clipped - 4 lines]
> Regards,
> Jillian

Reply to this Message