Hi,
I have a box on a form which allows me to select more than one option in it.
I want my query to return results based on what options are selected.
I tried using [Forms]![SearchF]![Category] in the criteria in the query design but my query just ignores any selections in this list and displays results regardless of their category.
Any ideas? I haven't made a multiple choice box like this searchable in a query before so have probably missed something basic.
Thanks.