J
j1eggert
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?
best method to use in referencing a large list on a form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
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.
though. Personally, I'd use a combo-box if you are saying that users need
to select an item from this list.
J
j1eggert
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
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
R
Rick B
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.
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.
J
j1eggert
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.