Combo box versus Listbox

[Mark Lees]

I created a table that is list of persons who provide services. It
will have 2 columns; ProviderId and Full name.

I need my users to select a service provider,so I want to create a
lookup to this table. What is the best way to get that list on a
form? Combo or list box? In other words what is the criteria for
using a combo box or listbox?

[PC Datasheet]

A combobox takes up less realestate on your form but it doesn't natively display
the list of choices.
A listbox displays its list of choices.

Each has special features that the other doesn't.
A combobox has autoexpand. If you turn this property on, you can start typing in
your choice and the list automatically scrolls to the choice.

A listbox can be made to return multiple selections by turning on the
multi-select property.

here are many other differences too.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com
"Mark Lees" <ma*******@byu.edu> wrote in message
news:c4**************************@posting.google.c om...

I created a table that is list of persons who provide services. It
will have 2 columns; ProviderId and Full name.

I need my users to select a service provider,so I want to create a
lookup to this table. What is the best way to get that list on a
form? Combo or list box? In other words what is the criteria for
using a combo box or listbox?

[Mark Lees]

THANKS!