Syntax (1 Viewer)

[TPugh]

Hi
I am trying to write a macro that finds a text box on an imeded form that is on a tab page.

If it were a text box on an imbeded form I would use [Forms]![MainForm]![SubForm].[TextBox]

With this syntax I get an error that says this is not an OLE object.

What am I doing wrong

Tom

 

[Robin]

Hello,
instead of [Forms]![MainForm]![SubForm].[TextBox] try
[Forms]![MainForm]![SubForm].Form.[TextBox]
hope that helps