Hi All, I want some help regarding "Update column from multi-select listbox". Actually i have 2 table.
1. tblUser: user_id(column1),user_name(column2)
2. tblTask: task_id(column1),user_name(column2)
I fave 1 form whare i have one listbox. it shows userdetails means usernames. and i have one command button "UPDATE"
I assume that in tblTask have 100 records and tblTask.username=null. and in tbluser i have multiple user.
...So how i update (through query or code(vba)) like
After Update (tbltask)
task_id Task Details user_name 1 a User1 2 b User2 3 c User3
Thanks in advance....