Hey everyone!

One of my friends at school asked me to help him with a project where he is taking an email from Outlook and importing data into access. I've pretty much got it all figured out and working until I got to this problem of MultiValue fields which is apparently new in Access 2007. I found some code here which helped me understand that Access treats each one as a separate field, however it is not exactly what I want.

In my main table I have many fields and 3 of them are MultiValue fields which are linked to other tables with information (What would you like to do?, Academic Major, etc). I need to be able to "check" the values inside of the field using VBA.

So far the only semi-solution I've found is deleting all the values from the MultiValue field and adding my own.

Any help/comments/snide remarks would be appreciated!
Thanks!