List Box linked to a Search Query

[atol]

Hello,

I have been searching the forum for this scenario but could not find similar case, which is as follows:
I have a Search Form with many Text and Combo boxes, linked to search criteria in a query. There is also a sub-form showing the search results.
I am trying to replace one of the combo boxes on the form, with a List Box, so I can make multiple selections. For example instead of showing only "buy" transactions via the combo, I want to see both "buy" and "sell" transactions, which I believe could be done via a List Box.

For the combo box I have the following:
In the Field section I have:
[TransactionType]=[Forms]![frmSearchTransHist]![cboTransType] Or [Forms]![frmSearchTransHist]![cboTransType] Is Null

For Criteria I have - "True"

So, my question is what should I put on the query in order to make it work with a list box.

I also want to give credit here to Jon K who has an example of database with combos and texts - very helpful example!
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

Any help is greatly appreciated!
Rgds,
Atol

 

[EMP]

To use a list box in the query criteria for multiple selections, you have to use VBA code.

See Jon K's another sample database in this thread:-
http://www.access-programmers.co.uk/forums/showthread.php?t=143670

^

 

[atol]

Thanks a lot EMP. This will help me a lot.