how to allow user to select multiple records from one column

[andrea]

Please help! I have an input form designed with a lookup
field to allow user to select multiple records from one
collumn of a table. I tried to use listbox with
Multivalue settings: this will display all the values all
the time with highlighting the selected. But I want to
user to be able to display the selected values only.
Combobox only allows to select one value. Please help.

 

[Albert D. Kallal]

The best solution is to use a continues form with a combo box. You simply
select a value from the combo box, and then move down to the next line and
then select another value form the combo box.

 

[andrea]

Thanks for your help. What's a "continues form"???

 

[BK]

Check this out:

http://www.mvps.org/access/forms/frm0007.htm

instead of making the string a SQL Statement, make it a string that
fills another text box on the form. Run it in an AfterUpdate event of
your list box. after every iteration through the list you'll want to
put a vbcrlf so that in the text box it puts each value on its own line.
I would build the string and then set it equal to the textbox. This
is completely off the top of my head (with the help of the Access Web as
well ), but it should work. You'll still have one listbox with all
the columns but then the textbox will just show those that are selected.

GLHF,
Bill

 

[Albert D. Kallal]

Take a look at the sample northwind database included with ms-access.

A continuous form is simply a regular form, but you switch the view to
continues view.

Here is some screen shots of a continous forms.

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

Basically, any time you need repeating data, you can use a continuous form

The setting to place a form into continues mode is in the format tab, and
the option is "default view"

 

[Guest]

Bill, Thanks for the help! I'll try your solution!