Link to home
Start Free TrialLog in
Avatar of deanlee17
deanlee17

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.
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of deanlee17
deanlee17

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.