modify forms in other databases

[kuanli]

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 in advance.

Kuan

 

[Rolliee]

open them in DOA or ADO and do the same as with currentdb()


Rollie E

 

[kuanli]

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&quot
dbs.TableDefs("Table1&quot.Fields("Name&quot.Name = "Lead"

Or I can do this (Access Object):
DoCmd.OpenForm "Form1"
Set thisForm = Forms(0)
thisForm.Controls("status&quot.RowSource = "inProgress"

But I cannot link them together. In other words, I cannot modify form (access object) in the database that I opened (DAO).

Kuan