how to allow user to select multiple records from one column

  • Thread starter Thread starter andrea
  • Start date Start date
A

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.
 
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.
 
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
 
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"
 
Back
Top