VBA help needed to update table based on list box multi selected records

krjoshi

New member
Local time
Yesterday, 20:35
Joined
Nov 18, 2014
Messages
2
Hi Folks,

I have database with an userform called “AssignWP”, combobox called “WPDevBy”, listbox called “List352” (Multi select) and table called “Justified”.
I am trying to update one field “WPDevelopedBy” of the table as combobox value based on list box multi selected records
I have attached the Database and picture of what I am trying to accomplish.

Thanks in advance,

Joshi
 

Attachments

  • WorkPackTracker.zip
    WorkPackTracker.zip
    645.9 KB · Views: 112
  • Picture.jpg
    Picture.jpg
    76.6 KB · Views: 142
There is no way to directly put a multI select data into a field.
You can use some code to put it in using some kind of divider, but you will also have code to read it from the field
 
Does the change fulfilled your requirement, (database attached)?
 

Attachments

Users who are viewing this thread

Back
Top Bottom