nosferatu26
Registered User.
- Local time
- Today, 10:17
- 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!
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!