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

Two multiselect listboxes

P: n/a
I have a report that gets its criteria from an unbound form. The form
has three fields: Month, System, and TechID. I would like to use two
mulitselect listboxes to allow the user to select more than one month,
for more than one TechID. I have the code to use for one multiselect
listbox, but I don't know how to change it to use two listboxes. Can
anyone help me? I am a novice when it comes to using VBA.

TIA,

Lee

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
use this code to do the first listbox:
http://www.mvps.org/access/reports/rpt0005.htm

and then just AND the two sets of criteria together... e.g.

....WHERE TechID IN (1,3,5)
AND Month IN (1,2,8)

then pass the filter in the OpenReport command to filter the records.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.