I have created a database in Access 2007 and then upgraded to 2010 to try to correct this problem. This particular form will not correctly display my data when I tell it to. I have included an image that shows the incorrect and correct displays. The Produce field does what I want which is gives me a drop down list that I can edit if I need to so if a new item comes up I don't have to close this form and open the table to add the new data. Works great! The Produce Description field won't work this way. It gives me this double arrow field that goes up and down and doesn't give me the entire list to pick from. It only displays one option at a time. The other fields won't properly allow editing. I have set them up in the same way so I can edit the tables if I need to but the form won't display them this way. I have tried creating a brand new form from scratch and it doesn't change the outcome. The control page is also displayed below to show how I have set up those controls.
Please let me know if you need anything further to help. I have been trying to solve this for DAYS! Please help!