Combo Box vs List Box

[LMB]

I always make combo boxes on my forms for look up lists because I know how
<g> What is the best way to create a look up list, combo box or list box and
why?

Thanks,
Linda
"A self taught database maker
who is working on signing up
for some classes at the local
university eventually <g>"

 

[Joe Fallon]

Cbo is probably preferred in most cases because it takes up less room.

Listboxes are great for short lists and multiple selections.

 

[LMB]

Thanks, Joe. I am glad I am doing something right. What would be an
example of a multiple selection?

Linda

 

[Sandra Daigle]

Suppose you want to run a report to include data for several customers - by
using a listbox with the MultiSelect property set to "simple" or "extended"
your user can highlight several customers and then click a button to open
the report. Granted, you have to create the code to build a filter for the
report but it makes a nice interface whenever you require user input that
requires multiple selections.

 

[Joe Fallon]

What she said!
Hi Sandra.
(Sorry I missed you at the conf. this year.)
--
Joe Fallon
Access MVP

Suppose you want to run a report to include data for several customers - by
using a listbox with the MultiSelect property set to "simple" or "extended"
your user can highlight several customers and then click a button to open
the report. Granted, you have to create the code to build a filter for the
report but it makes a nice interface whenever you require user input that
requires multiple selections.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Thanks, Joe. I am glad I am doing something right. What would be an
example of a multiple selection?

Linda

 

[Sandra Daigle]

I missed you too!

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

What she said!
Hi Sandra.
(Sorry I missed you at the conf. this year.)

Suppose you want to run a report to include data for several
customers - by using a listbox with the MultiSelect property set to
"simple" or "extended" your user can highlight several customers and
then click a button to open the report. Granted, you have to create
the code to build a filter for the report but it makes a nice
interface whenever you require user input that requires multiple
selections.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Thanks, Joe. I am glad I am doing something right. What would be
an example of a multiple selection?

Linda

Cbo is probably preferred in most cases because it takes up less
room.

Listboxes are great for short lists and multiple selections.
--
Joe Fallon
Access MVP



I always make combo boxes on my forms for look up lists because I
know how <g> What is the best way to create a look up list, combo
box or list box and why?

Thanks,
Linda
"A self taught database maker
who is working on signing up
for some classes at the local
university eventually <g>"

 

[LMB]

I assume you can't do the same with the list from a combo box?

Thanks,
Linda

Suppose you want to run a report to include data for several customers - by
using a listbox with the MultiSelect property set to "simple" or "extended"
your user can highlight several customers and then click a button to open
the report. Granted, you have to create the code to build a filter for the
report but it makes a nice interface whenever you require user input that
requires multiple selections.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Thanks, Joe. I am glad I am doing something right. What would be an
example of a multiple selection?

Linda

 

[Sandra Daigle]

Not really - the nice thing about making multiple selections this way is
that you don't have to store them anywhere.

You could create a table of selections and then use a continuous form with a
combo box for making selections. Then your selection table would contain a
single row for each selected customer. Quite feasible but not quite as nice
for the user since the user has to navigate through the list for each
selection (since only one can be selected at a time with a combo).

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I assume you can't do the same with the list from a combo box?

Thanks,
Linda

Suppose you want to run a report to include data for several customers -
by using a listbox with the MultiSelect property set to "simple" or
"extended" your user can highlight several customers and then click a
button to open the report. Granted, you have to create the code to build
a filter for the report but it makes a nice interface whenever you
require user input that requires multiple selections.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Thanks, Joe. I am glad I am doing something right. What would be an
example of a multiple selection?

Linda

Cbo is probably preferred in most cases because it takes up less
room.

Listboxes are great for short lists and multiple selections.
--
Joe Fallon
Access MVP



I always make combo boxes on my forms for look up lists because I
know how <g> What is the best way to create a look up list, combo
box or list box and why?

Thanks,
Linda
"A self taught database maker
who is working on signing up
for some classes at the local
university eventually <g>"