Comparing two queries with VBA

nosferatu26

Registered User.
Local time
Today, 06:47
Joined
Jul 13, 2015
Messages
57
Hi,

I am trying to compare differences between two queries. In my form, I have 2 multi select list boxes displaying similar information and I think it would be ideal to be able to press a button and then the list boxes will only select items that don't exist in the other. I was thinking about maybe using for loops and just comparing them that way but I was wondering if there is a more efficient way to do this; maybe creating record sets of each list boxes row source or something. Any advice on finding the best approach would be greatly appreciated!
 
My first thought is a query built using the unmatched query wizard comparing one query to the other.
 

Users who are viewing this thread

Back
Top Bottom