Modify form in another database

[kuanli]

Could someone please show me how I can modify the rowSource of a form in aother database using VB? I'm in desperate need.

Thanks in advance.

 

[LittleSmudge]

Forms don't have ROWSource properties.

So the simple answer is NO.

What is it that you are actually wanting to do ?



G LS

 

[kuanli]

Thanks for the reply.

I want to modify the rowsource of a control in a form.

I got something like this:

Dim appAccess As Access.Application
Dim strDB As String
Dim strFormName As String

' Initialize string to database path.
strDB = "c:\AA_xx\Workplan.mdb"
' Initialize string to Form name.
strFormName = "frmWorkPlan"

Set appAccess = _
CreateObject("Access.Application&quot

' Open database in Microsoft Access.
appAccess.OpenCurrentDatabase strDB

' Open form
' appAccess.DoCmd.OpenForm strFormName

Forms(0).Controls("status&quot.RowSource = "inProgress"

But the last line didn't work. Access complains that the form cannot be found.

Kuan

 

[LittleSmudge]

Why are you using Forms(0) when you know the name of the form ?
Why not use Forms!frmWorkPlan!Status.RowSource =

Is Status a Combo Box control ?

Is inProgress the name of a Table or Query ?


Is this remote database open at the time you are running this code - or are you attempting to edit the design of a closed form inside a closed database ?


G LS