how can I have more than 20 fields in a dropdown

D

Di

What is the best way to create a dropdown of more than 20 choices? The
lookup values in a table seems to limit you to this number
 
J

Jeff Boyce

Why?

What business need are you trying to solve?

What will having "more than 20 fields in a dropdown (?combobox)" allow you
to do?

Jeff
 
K

KARL DEWEY

What is the best way to create a dropdown of more than 20 choices?
Do not use lookup fields in a table.
Use a table containing the choices as source for combo box in your form.
The lookup table can contain as many as you need, one per record.
 
Top