<div>
Try to upload a working model of the database.<br />
Show a completed query and explain what improvement you expect.
</div>


<div>
I might be missing the point of the question. &nbsp;If so, please clarify.<br />
<br />
Access supports the IN operator:<br />
<a href="https://support.office.com/en-us/article/in-operator-d5a10cdc-cdb2-4854-be22-7abdeb5a3236" rel="ugc">https://support.office.com/en-us/article/in-operator-d5a10cdc-cdb2-4854-be22-7abdeb5a3236</a><br />
<br />
So just select where category IN ('category1','category2')<br />
<br />
I might also point out that the design doesn't look normalized.<br />
<br />
Off the top of my head: &nbsp;I had several releases on both CD and Cassette (yes, I'm old) and don't some releases cross genres?
</div>


<div>
The relationship between title and genre is incorrect. &nbsp;This should be a m-m relationship to support a title being multiple genres. &nbsp;Genre needs to be in a separate table:<br />
<br />
tblTitleGenre<br />
TitleID<br />
GenreID<br />
<br />
Create a unique index on the combination of title and genre.
</div>


<div>
There is only one genre per title so the one to many relationship is correct. &nbsp;Yes I too have releases on LP, and CD but again the title is “different” because the media type is different. &nbsp;In some cases I have a duplicate title AND media type but the purchase date and/or source and/or price are different. &nbsp;<br />
<br />
What I need to know is how to create on the fly using a form selecting one or more genres and create a query from those selections...
</div>


<div>
<blockquote>
There is only one genre per title so the one to many relationship is correct. 
</blockquote>
We must have a different definition of genre but if by your definition no title can ever be considered multiple genres then do what you want. &nbsp;In my opinion, your decision is short-sighted.<br />
<br />
Given that no title can belong to more than one genre, selecting multiple genres for a search doesn't make much sense but again - whatever.<br />
<br />
Netminder gave you a link to the definition of In() &nbsp;but he gave you no help in how to build the clause so here is code from one of my apps.<br />
<br />
Build the In() clause:<br />

<pre><code class="code-10 nolinks" id="code-20-42787382-1"><span>    Me.txtSelectedSequences = Null</span>
<span>    For Each i In Me.lstSequence.ItemsSelected</span>
<span>        strIN = strIN &amp; QUOTE &amp; Me.lstSequence.ItemData(i) &amp; QUOTE &amp; &quot;,&quot;</span>
<span>    Next i</span>
<span>    If strIN &amp; &quot;&quot; = &quot;&quot; Then</span>
<span>        Me.txtSelectedSequences = Null</span>
<span>    Else</span>
<span>        strIN = Left(strIN, Len(strIN) - 1) ' remove trailing comma.</span>
<span>        Me.txtSelectedSequences = strIN</span>
<span>    End If</span>
</code></pre>
<br />
Use the In()<br />

<pre><code class="code-1 nolinks" id="code-20-42787382-2"><span>    If Forms!frmVariables!txtSelectedSequences &amp; &quot;&quot; = &quot;&quot; Then</span>
<span>    Else</span>
<span>        strSQL = &quot;SELECT * FROM &quot; &amp; Forms!frmVariables!txtExcelQueryName &amp; &quot; WHERE &quot;</span>
<span>        strSQL = strSQL &amp; &quot; PhaseSeqNum In (&quot; &amp; Forms!frmVariables!txtSelectedSequences &amp; &quot;) OR forms!frmVariables!txtSelectedSequences is null;&quot;</span>
<span>    </span>
<span>        Me.RecordSource = strSQL</span>
<span>    End If</span>
</code></pre>
<br />
Note that you CANNOT pass the In() clause as a variable. &nbsp;If you use this technique, you must build the SQL string with VBA.
</div>


<div>
Ok, almost there! &nbsp;The only question I have left is how do I construct the form to get the variable Me.txtSelectedSequences and then put that into the code you provided.<br />
<br />
Giving a title multiple genre's never made any sense to me. &nbsp;In order to file the title it is better to do by genre and to do that you have to have one main genre to do this by otherwise you have a confused mess on your hands, in other works, Rock, New Age, Country, Soundtrack, Movie Trailer Music, etc.
</div>


<div>
I am waiting for a demo database if issue not resolved before 10 comments.<br />
I don't expect to create a new database for each question.
</div>


Photographer

Fred Fisher

<div>
<div class="content wysiwyg-content">
I have a rather complex music database that I have been working on since September. &nbsp;I am at the point where the basic structure of the database is in place, I have entered in 75% of the data (1,795 Media Titles, 19,000 Songs) and have some basic reports and queries set up but now I am moving into some more complex queries. &nbsp;The database has 11 Genre (Music Categories) and I have a way of doing a query on any one category but I would like a way to do it by a selection of categories.<br />
<br />
I would like to have a form listing the categories alphabetically with the ability to select one or multiple categories based on what is selected on this form. &nbsp;This would involve tblTitles and tblGenre. &nbsp;The tblGenre is a lookup table containing the categories. &nbsp;<br />
<br />
Twenty years ago I was heavily involved with VBA and Access but I have not used it since and I have forgotten everything but the basics. &nbsp;How do I go about doing what I would like to get done here?<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/01_w05/1410921/2019-01-30-Relationships-Music-Manag.JPG" target="_blank" class="file-inline" title="Relationships Music Manager (401 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>2019-01-30-Relationships-Music-Manag.JPG</a>
</div>
</div>


2019-01-30-Relationships-Music-Manag.JPG

I have a rather complex music database that I have been working on since September.  I am at the point where the basic structure of the database is in place, I have entered in 75% of the data (1,795 Media Titles, 19,000 Songs) and have some basic reports and queries set up but now I am moving into some more complex queries.  The database has 11 Genre (Music Categories) and I have a way of doing a query on any one category but I would like a way to do it by a selection of categories.

I would like to have a form listing the categories alphabetically with the ability to select one or multiple categories based on what is selected on this form.  This would involve tblTitles and tblGenre.  The tblGenre is a lookup table containing the categories.  

Twenty years ago I was heavily involved with VBA and Access but I have not used it since and I have forgotten everything but the basics.  How do I go about doing what I would like to get done here?

Create query on the fly with multiple selections

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.