I have an access database that I am using in a visual basic shell. I have several forms with comboboxes that use lookup tables as their data source. My problem is this, I know that you can input your value instead of selecting from the combo list. However, I could swear that I had some setup a couple of years ago such that the user input would be added to the combo list. I have researched until my eyes hurt and messed with my combo boxes so much that I can hardly recognize them anymore and am still unable to find out how I did this in the past (perhaps I am just imagining that I did that). If anyone is familiar with this property I would sure appreciate your response.

By the way, anyone using comboboxes and lookup tables for their data source might consider putting all of their lookups in a single table and just use the field that is needed for a specific combobox. It really makes it easier to keep track of the lookup data. I had over 100 single field lookup tables and have reduced that to just 4.