asked on
Ms Access loses value list after form close
Hi guys,
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.
Thanks,
Dean.
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.
Thanks,
Dean.
Microsoft Access
Last Comment
deanlee17
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.