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.
Microsoft Access

Avatar of undefined
Last Comment
deanlee17

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Dale Fye

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck