I need to add values to a combo box from a textbox. I can add the value into the value list row source using List42.AddItem ("Var1") But when I close the form and re-open it, it loses Var1. Ive tried DoCmd.save but that doesnt work.
Personally I would have added the values to a table and used and SQL query to look them up. But I have inherited this database.
Well that explains that one then. I wanted to leave the database (relatively) the way I found it, incase this gets handed back. But as you suggested, I am going to make changes and create a lookup table.