sourceobject command

[johnsaw]

i have a oleobject on a subform and i want to get the path and name of the inserted object, my mainform is newpostassign and my subform is subassign, my object is Title.

I thought Forms!newpostassign.Form!subassign!Title.SetFocus
myfile2 = Forms!newpostassign.Form!subassign!Title.SourceObject
MsgBox (myfile2)
would put the objectsname in a message box but all i get is run time error 438 object doesn't support this property or method.

 

[The_Doc_Man]

If the Title item in your subform is a label rather than a text box, you cannot use the .SetFocus method to get there. You cannot set focus to a label.