Update Column from Multi-select listbox

[jhargram]

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....

[pbaldy]

I'm not clear on the question. Is this what you want?

http://www.baldyweb.com/MultiselectAppend.htm

[jhargram]

If you see tha attached access file and if you open Allocation formyou can see there i have two listbox.
1. User (multiselect)
2. Task


and I have one commandbutton (submit)


My question is if i select more then 1 user from userlist and if I select one task there and press submit then it should update in tbl_task.




Like exm:
In tbl_task there are 4 "xxx". Now if i select "abc" and "bcd" from userlist and from task if I select "xxx" and press submit button then in tbl_task it should update in user "abc" first2 "xxx" and last2 "xxx" as user "bcd"

[pbaldy]

What rules determine which records get updated to which user? What if 3 users were selected? We need a set of rules to follow to guide the code.

[jhargram]

Thanks pbaldy for response, Actually it should come like total task divided into selected username.