Selecting multiple records from a lookup feild(Table) - how to ???

[Guest]

Hi al
I'm in a situation where I need to select multiple records from a lookup feild in a Table -
I have my big table which some of its colume fields draw data from other small tables throu a lookup feil
It would be a massive time saving if I could select few records from the drop down list, instead of one at a tim

Is it possible
If so - would you be so kind and show me ho

Thank you for your tim
Yari

 

[Cheryl Fischer]

If, when you say 'drop down list', you are referring to a Combo Box control,
only a single selection is allowed.

If you are referring to a List Box control, you can use the MultiSelect
property, changing it from 'None' to either 'Simple' or 'Extended' to allow
for selection of multiple items.

hth,

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Hi all
I'm in a situation where I need to select multiple records from a lookup feild in a Table -
I have my big table which some of its colume fields draw data from other

small tables throu a lookup feild

It would be a massive time saving if I could select few records from the

drop down list, instead of one at a time

 

[Guest]

Thank you for your quick respons
This is exactly what I nee
It would make a dramatic change in my wor

I did try to change the Combobox Display control to a Listbox control
I did not find any "MultiSelect property" in the lookup parameters in design vie
Does it involve scripting - changing it to simple or extended

Can you please be a bit more specific on exactly how to set this property
It means the world to m
Thank you for your tim
Yariv

 

[Cheryl Fischer]

When you open the Property Sheet for a List Box control, click the "Other"
tab. The MultiSelect property is in that section. Click anywhere in the
MultiSelect row and a downward pointing arrow (combo box) will appear at the
right edge of the row. Click the arrow and your choices will be displayed.

 

[Guest]

Hi chery
I'm embarresed - I can't find any "Other" ta
when you say - "open the Property Sheet For a List box control", you do mean right click - properties - ... right
And just to make sure - we are talking of the same situatio
it is a table on access 2003 if it makes any differense..
I'm running out of ideas here..
But it is still very important for m
Thanks again cheryl !!
Yari
Tel avi
Israel

 

[Cheryl Fischer]

Well, now I am embarrassed, Yariv! I re-read your initial message and
realized that you said you wanted to do this *in a table*, while I zoomed in
on *drop down list* and thought of a form.

I am sorry to say that with a Lookup field in a table, you get one and only
one selection.


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Hi cheryl
I'm embarresed - I can't find any "Other" tab
when you say - "open the Property Sheet For a List box control", you do

mean right click - properties - ... right ?

 

[Guest]

Hi cheryl
Somehow I had that funny feeling that we are talking on two different objects...
Thank you for your effort anyway !
I will try to see how can I combine a form to fill in the data and use this feature
thanks again for your kind attention !
Yariv