Combo Box vs List Box

  • Thread starter Thread starter LMB
  • Start date Start date
L

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>"
 
Cbo is probably preferred in most cases because it takes up less room.

Listboxes are great for short lists and multiple selections.
 
Thanks, Joe. I am glad I am doing something right. What would be an
example of a multiple selection?

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.
 
What she said!
Hi Sandra.
(Sorry I missed you at the conf. this year.)
--
Joe Fallon
Access MVP



Sandra Daigle said:
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
Click to expand...
Click to expand...
 
:-)

I missed you too!

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


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

Sandra Daigle said:
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>"
Click to expand...
Click to expand...
Click to expand...
 
I assume you can't do the same with the list from a combo box?

Thanks,
Linda

Sandra Daigle said:
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
Click to expand...
Click to expand...
 
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

Sandra Daigle said:
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>"
Click to expand...
Click to expand...
Click to expand...
 
Back
Top