I have added a new combobox to a form and am having a hard time getting it setup. I have a list of values that I want to make available to the users, however the list is too long to put into the RowSource field. What other option do I have to display the list to the user?

Also, the value the user selects will be stored in a table. When I exit out of the form and reenter, the combobox does not show the value that is saved in the table. What am I doing wrong here? I have set the Controlsource to table.field but that doesn't seem to be working.

Your help is appreciated!