Comparing multivalue combo box to multivalue table/query field (1 Viewer)

Kronix

Registered User.
Local time
Today, 11:42
Joined
Nov 2, 2017
Messages
102
I have a table with a multivalue field. I have a search form with a combo box where multiple predefined search items (corresponding to the possible values of the multivalue field) can be selected. I want to filter the query based on the table so that it only shows records whose multivalue field contains all of the items selected in the combo box on the form.

How do I perform this comparison?
 

Kronix

Registered User.
Local time
Today, 11:42
Joined
Nov 2, 2017
Messages
102
No answer for this? Do I have to write complicated VBA code just to cycle through and compare the values of both multivalue fields?
 

Users who are viewing this thread

Top Bottom