listbox textbox combination

[wannabe]

I have a table with over 700 records in it which I have in a list box so that I can maintain the integrity of my data. This table consists of the MCA Codes (Montana Code Anotated).
I have download a copy of code written by Ken Getz called With Events. This allows the user to start typing the charge in a textbox and as the user types it jumps through the list box as each letter is typed.
However, the user many times will need to select multiple charges that a defendant has committed. I have decided to use this combination as it would take too much time for the user to scroll through the list tyring to find all the records that they need. I have tried setting the listbox to multi-select but my textbox stop working.

Does anyone know of any way of dealing with this? I'm still fairly new at VBA so I would appreciate detailed information.


TIA
Emily

 

[Travis]

I concure with Pat. The main point is that a multiselect List Box does not have a single referenceable value and thus does not save any data to the table field it is linked to. Using a seperate table and adding its form as a subform to the main table you can easily add as many charges as you would like to a defendant. (Also the combo box has a property that alows the user to just start typing and it will take you to the closest match like Mr. Ken Getz code.)