How to create a multiSelect list box?

[jo]

Hi I am trying to create a multiSelect list box, form consists of 2 boxes.
the user would select an item and this would show in the opposite box etc..
then hopefully create a report to show these results. Does any one have a
step by step instruction on how to do the coding??? I am trying to use the
coding from Microsoft Access 2000 Bible (I have 2003 Access) but I am not
quite understanding the coding?? This is also where I got the idea from..
Jo

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), are two small Access database
samples called "MoveList1.mdb" and "MoveList2.mdb" which illustrate how to
do this. MoveList1 is the simpler of the two and shows the basic process
for a single-user environment. MoveList2 shows how to do it with a
multi-select listbox and also has an example for use in a multi-user
environment. I suggest you work through MoveList1 first, even if you want
multi-select or multi-user functionality.

There is not step-by-step explanation, but you have a working example to
tear apart.

You can find them here:
MoveList1.mdb
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=324
Movelist2.mdb
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=323

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[jo]

Hi Roger thanks for your help I have looked at you site very helpful but
still not able to find a solution to my problem I have built the form with
the list etc but I need the items selected to show somewhere that they have
been checked in or out. Having the report to show what you have selected is
good but I also need to see in a table or query that these items have been
checked in or out. would you be able to help me further?? thanks Jo