troubleshooting Question

Ms Access loses value list after form close

Avatar of deanlee17
deanlee17 asked on
Microsoft Access
2 Comments1 Solution404 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros