Error in code.....addressing form from subform

[terre]

The following code

Dim Pth As String
Dim frmName As String

frmName = "DLO1"
Pth = "C:\XXX"

Forms!frmName![Photos].Form!PathtoDoc = "#" & Pth & "#"

gives the error

Cant find Form frmName

What am I missing please?

 

[JoeAtWork]

More likely you want:

Forms!DLO1!PathtoDoc = "#" & Pth & "#"

If you want to reference forms with a variable, you can't use bang notation. Instead:

Forms(frmName).Controls("PathtoDoc") = "#" & Pth & "#"

 

[terre]

Thank You Joe

Forms(frmName)![Photos].Form!PathtoDoc = "#" & Pth & "#"

Works fine

 

[BSman]

If you are working in the subform, you can also reference a control in the main form like this:

Me.Parent.PathtoDoc

Bob

 

[terre]

Thanks BSman

The code is in a function.....and wont let me use Me.Parent

And frmName is a variable ... as is PathToDoc

But it works now....thanks muchly