<div>
I would strongly recommend against using a multi-value field. &nbsp;These were a bad idea when Microsoft created them and remain a bad idea to this day. &nbsp;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.<br />
<br />
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.
</div>


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.

<div>
I prefer to user this feature. Do you know how to reference as I am asking?
</div>


I prefer to user this feature. Do you know how to reference as I am asking?

<div>
<div class="content wysiwyg-content">
I have a multi value field in VBA with 3 values the user can select Catalog, Email and Web Only. &nbsp;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.<br />
<br />
Thanks
</div>
</div>


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

reference multi value field in VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.