reference multi value field in VBA

I have a multi value field in VBA with 3 values the user can select Catalog, Email and Web Only.  I want to add some VBA so after the selection if the user has selected the Web only Check box, it deselects Catalog and Email. I tried briefly with myfield.value but mad no progress.

Thanks
vmccuneAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
I would strongly recommend against using a multi-value field.  These were a bad idea when Microsoft created them and remain a bad idea to this day.  They are extremely difficult to work with, hide the actual data from the user in two hidden and inaccessable tables (one for the values and one for the values associated for each record), and are extremely difficult to query.

You are far better off creating your own tables and creating either a multi-select listbox or a subform to display the options in your form.
vmccuneAuthor Commented:
I prefer to user this feature. Do you know how to reference as I am asking?
PatHartmanCommented:
You have to work with the field as a recordset (because that is what it is).  This example shows how to work with the MVF.
http://allenbrowne.com/ser-42.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.