<div>
I would recommend against using multi-valued fields. &nbsp;Personally I believe they are a mistake and should be avoided.<br />
<br />
What are you trying to do with the values from the list? &nbsp;Normally, if you are going to use a list that allows you to select multiple items from the list, you are going to need a table that stores those in a table with a one-to-many relationship to the main record that the form is tied to. &nbsp;<br />
<br />
Unfortunately, that also means that the list will not be bound to the main record and you will have to write those selected items to a table when you save the record, and if you come back to that record (Current Event), you will need to read from your one-to-many table and highlight (SELECT) those items in the list again.<br />
<br />
To write the values to a table, you might use code similar to:<br />
<br />
Dim varItem as variant<br />
<br />
for each varItem in me.lstYourListName.itemsse<wbr />lected<br />
<br />
&nbsp; &nbsp; strSQL = &quot;INSERT INTO someTable (ID, ListID) &quot;&nbsp;_<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&nbsp;&quot;Values (&quot; &amp;&nbsp;me.txt_ID &amp;&nbsp;&quot;, &quot;&nbsp;&amp; me.listYourListName.column<wbr />(0, varItem) &amp;&nbsp;&quot;)&quot;<br />
&nbsp; &nbsp; currentdb.execute strsql, dbfailonerror<br />
<br />
Next<br />
<br />
written on my iPad, so there might be some syntax errors.
</div>


<div>
I also do not use multi-value fields. &nbsp;They are really more trouble than they are worth. &nbsp;Create a normal 1-many relationship. &nbsp;Use a subform for the many-side data. &nbsp;Using a subform is essentially a no-code solution. &nbsp;You can make the subform innocuous so it blends in with the main form if you wanted more of a list effect.<br />
<br />
The only benefit of using a multi-value field is the nice display options. &nbsp;Everything else is a problem.
</div>


<div>
Thanks &nbsp;fyed &nbsp;and PatHartman,<br />
My requirement is to assign multiple members(users) to different rooms. I have a form and table for room details and from the same form i have to assign the members to it. The form is user defined and not linked to any data/table records. <br />
I was thinking to add two list boxes to the same form - one to select the users and other to show the selected users and then to submit. I am not sure this method is right or wrong but from the user end I think it will be easy for them. <br />
I am not sure how the other method (subform) works.. to save/edit each emplooyee shall we need to go through each subforms? Please Help.<br />
Thanks
</div>


<div>
<blockquote>
The form is user defined and not linked to any data/table records. 
</blockquote>
Are you saying that you didn't create the form but the users are allowed to create their own forms in a shared database? &nbsp;-- Big problem waiting to happen.<br />
<br />
If this is a one to many relationship, the room is actually stored in the member record. &nbsp;If this is a many-to-many relationship, it needs a third table to implement.<br />
<br />
I've attached an example of a many-to-many relationship and how to manipulate it from either side.<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/01_w01/826305/ManyToManyAXP.mdb" target="_blank" class="file-inline" title="many-to-many example (420 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>ManyToManyAXP.mdb</a>
</div>


ManyToManyAXP.mdb

<div>
Sorry for the dealy - I was off from work.. If i use listbox or combobox - whats the best way to store the data to the table of the selected items from it? save multiple selected items in to a field or any other way to store? May be the answer of this question will give me the solution. Please help.<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I am working on an access form to save multiple values(id's) &nbsp;from a list box to the database field. I have to use those values in another form(may be in the same form) to edit... So my question is, do we have any other better options to do this type of functions(adding multiple value to db and retrieve it update later) in Vba and Access forms..Please help..<br />
Thanks
</div>
</div>


Hi Experts,
I am working on an access form to save multiple values(id's)  from a list box to the database field. I have to use those values in another form(may be in the same form) to edit... So my question is, do we have any other better options to do this type of functions(adding multiple value to db and retrieve it update later) in Vba and Access forms..Please help..
Thanks

multiple values - list box save-edit

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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.