Re: select multiple items from dropdown

Tech-Archive recommends: Speed Up your PC by fixing your registry

And this is bad because??
what i want to do it use a dropdown list of names to select multiple names,
and then populate this to a field in a database.

- i earlier had a listbox in the form, this allowed me to enter one name.
Listboxes have a MultiSelect property. If set to Simple or Extended multiple
selections are allowed, but the default is None.
i set the multiselect properties to extended. when i select multiple items,
and hit enter - the field i linked it to does not get populated . do i need
to set something else too?

"George Nicholson" wrote:

- i earlier had a listbox in the form, this allowed me to enter one name.
Listboxes have a MultiSelect property. If set to Simple or Extended multiple
selections are allowed, but the default is None.

when i select another name, the previous name in the combo-box gets
over-written.

And this is bad because??

The only time I can imagine you would NOT want a combobox value to NOT
overwrite existing data is if you were trying to use one combobox for both
data entry and record navigation (which is a lousy idea: use 2), but you
haven't even hinted that's what you are trying to do, so I'm confused.
Sorry if I'm being dense. If you really do want to make multiple
selections, you need a listbox.

--
HTH,
George


"vc-programmer" <vcprogrammer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:747D9453-31F4-41E0-8850-48A5B84E9E9D@xxxxxxxxxxxxxxxx
allen: thanks for responding to my query. i am going through your
suggestion
to make it work, i will send a reply soon. the tutorials are well written,
my
compliments.

george : thanks for suggesting another way of doing it. i seem to be doing
something wrong to make it work, i have provided details of what i was
trying.
- a main table is populated with data using a form. one of the fields to
be
populated is a person's name, which is pulled from another table by a
look-up
which has names and serial numbers auto-numbered.
- i earlier had a listbox in the form, this allowed me to enter one name.
- i now created a combo-box in the form using the wizard. what happens is
that i select a name from the drop-down, it gets populated in the
combobox.
when i select another name, the previous name in the combo-box gets
over-written.

what am i doing in-correctly here? i want to be able to enter multiple
names
into the field. i guess i am missing something here...

thanks for your input.

"George Nicholson" wrote:

A combo box control (aka "drop down") only allows the selection of a
single
item. A list box allows multiple selections.

A combo box is designed to combine the type-a-single-value textbox with
some
of the preexisting list features of a listbox (hence the name Combo).
With
the right settings, a combo allows the addition of a new value to the
list
(similar to a text box) but a list box provides the user with no built in
method of adding to the provided list.

Afaik, none of this has changed in Access 2007, nor would any change be
desirable(IMO).

Afaik, if you want/need to allow multiple selections, you have to use a
listbox.
--
HTH,
George


"vc-programmer" <vcprogrammer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:39BA479B-A87D-42ED-AB67-073CB4447720@xxxxxxxxxxxxxxxx
hello everyone,

i have a table which is populated using a form. one of the fields is
person's name, the dropdown for which picks up data from a second table
(which has an index and person's name).

what i want to do is modify the form so that a user can select multiple
items from the dropdown, but i havent been able fo find a way to do
so.

i am using access 2003. i know that access 2007 lets you do that, but i
dont
have an option of upgrading right now.

i would appreciate your suggestions

thanks,
vc-programmer
.

Relevant Pages

  • Re: How do I add items to a comboBox in Word 2003 userForm?
    ... Your requirements are hard to meet, to have both multiple simultaneous ... selections and entry of items that aren't yet in the list. ... standard listbox allows multiple selection but has no way to enter new ... controls -- a listbox and a textbox -- plus a command button. ...
    (microsoft.public.word.newusers)
  • Re: select multiple items from dropdown
    ... selections are allowed, ... The only time I can imagine you would NOT want a combobox value to NOT ... If you really do want to make multiple ... - i earlier had a listbox in the form, this allowed me to enter one name. ...
    (microsoft.public.access.forms)
  • Showing records from a link table collectively?
    ... and then show every record the contains a specfic key with a multiple ... I'd like to be able to let the user select 1, and have a multiple ... select listbox show A, B, and F as selected. ... the selections as well. ...
    (microsoft.public.access.formscoding)
  • Re: Help with multiple selection list boxes...
    ... > What I need to do...IN THE SIMPLEST WAY...is to allow multiple countries ... > see what selections were made from the listbox. ...
    (microsoft.public.access.formscoding)
  • Re: select multiple items from dropdown
    ... george, i feel like an idiot for not reading your post carefully. ... but i have not been able to select multiple ... items in a form to populate a filed using that. ... - i earlier had a listbox in the form, this allowed me to enter one name. ...
    (microsoft.public.access.forms)