I need help on multi select

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I have 2 list boxes on a form. I want to make the user to
be able to make a selection in list box1 and then updates
a multiselection on list box2 with the selection the user
made in list box1. I was able to make it work when the
user updates one selection only, but when I changed the
list box2 <Multi select> property to Simple the code did
not work. can someone help?
thanks
 
Try this:

Create two Tables with data (t1 and t2).

Create two queries, q1 and q2
Base q1 on t1 and q2 on t2

On a form (f1), create two Listboxes (List1 and List2) and
make their RowSource equal to their respective queries: q1
and q2.

In List1
OnUpdate: Enter the code: Me![List2].Requery

In the criteria of a field listed in q1 AND q2, enter: =
[Forms]![f1]![List1]

Now, when you select data from the first ListBox, it will
immediatley update the second ListBox with "Filtered" data
meeting List1's selection. You, of course, will have to
play with field names, etc. email me if you need to.
 
Thank you for replying. May be it is my use of words that
lead you to this solution. I did not mean update as in
filtering I meant that the user can assign (add) the data
that he/she selected in list1 which is based on tbl1 to
list2 which is based on tbl2. tbl1 is a lookup tbl for
different systems. I want the user to select an item (a
system)from list1 that is the lookup list, and then, in
list2 (contains items that use the different systems in
list1) the user will select multiple items and then assign
the system selected in list1 to the items selected in
list2. I hope that I got it clarified this time.
thanks
 
Back
Top