Solved Two listboxes remove selections if used

[oxicottin]

Hello, I have two listboxes (CrewOneDelimitedEmployees) and (CrewTwoDelimitedEmployees) using the same employee list to select from. I want to be able to if I select data from (CrewOneDelimitedEmployees) then it should remove the selection from (CrewTwoDelimitedEmployees) so I can't select same data.

I figured I could in each listboxes row source add under the criteria a "Not In" for the empID but how?

Something like but doesnt work:

Not In (SELECT EmpID FROM tbl_Employee WHERE EmpD= [Forms]![frm_WeeklyAttendanceSheet]![CrewOneDelimitedEmployees])

 

[Gasman]

You need some sort of flag in the employee table to indicate which list box they should appear in.
When you select one, you set that flag or clear it and requery both listboxes.
That is one way that I have done it.

You really should try searching, even here.

Moving items between listbox

Hello, I have two listbox (SearchResults5 has two columns) and list_asset_add (one column) both have Extended multi-selection active. I have this code that automatically moves the items between the two listbox (it runs after pushing a button): Sub CopiTo_Click() Dim Msg As String Dim i As...

www.access-programmers.co.uk

 

[jdraw]

See this older video "Listbox trick" from DataPigs.

 

[Gasman]

Jack,
That liink I posted also has a link you posted.

 

[jdraw]

Paul,
I just saw the 2 listbox thing. I followed Datapig way back when, and then worked with Crystal and John to get the series back online. Crystal got access to the videos and arranged their storage
Lot's of good videos in the series. The links are in my signature.

 

[oxicottin]

Dang fellas im going to have to try this when I get back from the holidays! Ill post back next week....

Thanks,

 

[MajP]

Moving items between listboxes

I added a demo of a Large From to List with about 10K available. But no issue doing any size. As set up I would think no problem handling a several 100k you would need to slightly modify the code once you get into the millions so that you never go over the 60k limit. It is a combination of a...

www.access-programmers.co.uk