?
Solved

query criteria multi select list box

Posted on 2007-07-30
1
Medium Priority
?
457 Views
Last Modified: 2009-07-29
I have a query that pulls a project name from a combobox. The criteria is:
[Forms]![frmProjects]![cboProject]

I need to change the combobox to a listbox (multi select) so I can select more than one project.  The following criteria does not work: [Forms]![frmProjects]![ListProject]  

I want to keep this in a select query and not write sql statements.

Thanks.
0
Comment
Question by:Sasha42
1 Comment
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 19597524
Hello Sasha42,

That's not going to work with a ListBox.. You are going to need some code.

Regards,

Patrick
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question