CNeeper
asked on
Using VBA, how can I filter a table using a value in a multivalued field?
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.
Any help would be greatly appreciated!
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.
Me.Filter = "[Manufacturer] = '" & Me.Field_Filter_Manufacturer & "'"
Me.FilterOn = True
Any help would be greatly appreciated!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome! Those were the examples I needed! Thanks a million!
:)