<div>
Not really an answer to your question, but my advice is to get all Taylor Swift and never ever ever use multi-valued fields. &nbsp;Really.<br />
<br />
:)
</div>


Not really an answer to your question, but my advice is to get all Taylor Swift and never ever ever use multi-valued fields.  Really.

:)

<div>
Awesome! Those were the examples I needed! Thanks a million!
</div>


Awesome! Those were the examples I needed! Thanks a million!

<div>
<div class="content wysiwyg-content">
I have a table in MS Access 2013 that, among other fields, contains a multivalued field.<br />
<br />
Using VBA, I would like to filter the table based on a &quot;normal&quot; field AND by a value that might be contained in the multivalued field.<br />
<br />
I already have the following working code in place to filter the table based on the &quot;normal&quot; Manufacturer field, but I'm stuck on adding in the multivalued Categories field.<br />
<br />

<pre><code id="code-10-28301973-1">Me.Filter = &quot;[Manufacturer] = '&quot; &amp; Me.Field_Filter_Manufacturer &amp; &quot;'&quot;
Me.FilterOn = True</code></pre>
<br />
Any help would be greatly appreciated!
</div>
</div>


I have a table in MS Access 2013 that, among other fields, contains a multivalued field.

Using VBA, I would like to filter the table based on a "normal" field AND by a value that might be contained in the multivalued field.

I already have the following working code in place to filter the table based on the "normal" Manufacturer field, but I'm stuck on adding in the multivalued Categories field.

(CODE)

Any help would be greatly appreciated!

Using VBA, how can I filter a table using a value in a multivalued field?

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.