Access 2013 - creating a multiple select listbox - please help!

[alecf720]

Hi,

I’m trying to create a bibliographic database with MS Access 2013. Please bear with me as I'm a newbie to this...




I have created a search query form that uses three list boxes with multiple (extended) select. Basically, users should be able to search for articles by year (1991-2013), country, and keyword (i.e. politics, economy). Without multiple select, the search query works fine, i.e. just clicking one option from each listbox. But now if I click for example 1991 + 1992 and two countries, it returns no records.


Is this an issue of entering the correct criteria in the query design ( for example, [Forms]![Search Form 0902]![Year].[MultiSelect]) or am I getting into the realms of complex
programming?


Would really appreciate any help!

Alec

[orange]

Can you show us your database tables and relationships (jpg)?
You may be or may not be in the realm of complex programming. We don't know enough about you or your environment, or the business issue/problem or opportunity you are trying to solve. Please tell us more.

Is this a new database, or one converted from earlier Access or other?

It would help if we were a little more familiar with your situation.

Good luck with your project.

[alecf720]

Hi Orange,

Thanks for your reply! It is a new database - I only have Access 2013.

I've attached 3 JPEGS below - I hope they clarify a bit what I am doing. Basically, I'm creating a catalogue of journal articles that users can search by year, country, and keyword - so there are 3 listboxes. I can get it to work if only one option from each listbox is selected, i.e. 2008, Kazakhstan, Politics - it will return all the records that match all three selections. However, I can't get it to work with multiselect - for example, the user wants to find all records from 2006-2012 that concern two countries. I can set up multiselect on the search query form but it doesn't return any records when I press "run query".

In the design view I can set the criteria [Forms]![Search Q]![Year].[MultiSelect] - but it doesn't work - I've also tried other combinations.

Am I setting the wrong criteria and that's why it won't work, or is it a case of more complex coding to get this to work?

Thanks!!

Attachment 11189

[orange]

I don't have acc2013.
Can you show the SQL of the query for using multiple listbox values?

Or post a copy of your database in 2010 format.

[pbaldy]

I think you are into VBA. Here's a method for one listbox:

http://www.baldyweb.com/multiselect.htm

In your case you'd build 3 strings to end up with:

Field1 In(...) AND Field2 In(...) And Field3 In(...)

[alecf720]

Hi guys,

Thanks for your responses - really appreciate it.

I guess there is something with the strings I'm getting wrong. I did get an earlier version to work NOT using multi-select (the strings you see here are from that earlier version, but don't work now since I've been messing about with the mutli-select).

I'm going to attach a copy of the database here. It would be great if you could have a quick look and see if there is a quick fix or not.

Thanks very much!

Alec

test database 1902.mdb

[pbaldy]

Well, the code is incomplete, and is out in the middle of nowhere. It has to be a sub or function. In your case, it would typically be behind the button:

http://www.baldyweb.com/FirstVBA.htm