List Boxes and Drop Down Menus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list that has about 100 different items to choose from. What is the
best method to use in referencing a large list on a form?
 
Depends on what you want to do. 100 items is by no means a "large" list
though. Personally, I'd use a combo-box if you are saying that users need
to select an item from this list.
 
Okay, but what is the best way to reference the list in the combo box? In
other words, do I create a table with the items listed their and reference
the information to the combo box? And if so, do I use the Table/Query in the
Row Source Type and reference the tblTypeDoc in the Row Source? (tblTypeDoc
is the table I created that has this list in it). More detailed guidance
would be appreciated.

J. Eggert
 
Yes, I would create a table with the options. If there are 100 of them, I'd
assume they will be changed and updated from time to time, so you want them
stored in a table. You might also include an "inactive" checkbox if items
will be taken off the list from time to time. You could make a simple form
so your users can maintain the items in the table.

You could then build a query to only pull the active items.

The combo-box wizard will help you add the combo-box to your form and pick
the data source.
 
Thanks for your help!

Rick B said:
Yes, I would create a table with the options. If there are 100 of them, I'd
assume they will be changed and updated from time to time, so you want them
stored in a table. You might also include an "inactive" checkbox if items
will be taken off the list from time to time. You could make a simple form
so your users can maintain the items in the table.

You could then build a query to only pull the active items.

The combo-box wizard will help you add the combo-box to your form and pick
the data source.
Click to expand...
 
Back
Top