Look-up Wizard limited to 20 entries?

[LeiDBug007]

When creating the list of items to put in a look-up list (via the Wizard), it says we are only allowed and limited to 20 entries.

Is there any way to bypass that and make a bigger list, like 50 entries per se?

Thanx!!!

~LeiDBug007

 

[jamason07]

HiLeiDBug,

What you need to do is create a table or query with the items for your drop down. When creating the dropdown on the form, turn the wizard off. Using the create dropdown icon from the menu, select properties and then select your table or query in the "control source". This will allow you to edit your dropdown list from your table. By creating a query from your table, you can then set the sort parameters if you want to order the items. Good luck!

Jeffrey