I need to modify the value list of a certain list box in some forms. I know how to do it for the currentProject. But I need to do the same modification for forms in about 30 different databases. How do I do that?
Thanks for the reply, but I still don't know how to do it. I think I'm missing something very basic here.
I can do this (DAO):
Set dbs = OpenDatabase("s:\Workplan-final.mdb"
dbs.TableDefs("Table1".Fields("Name".Name = "Lead"
Or I can do this (Access Object):
DoCmd.OpenForm "Form1"
Set thisForm = Forms(0)
thisForm.Controls("status".RowSource = "inProgress"
But I cannot link them together. In other words, I cannot modify form (access object) in the database that I opened (DAO).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.