error 2455 calling public sub in main form from subform (1 Viewer)

[ozinm]

Ok,
I've got a weird one here i can't work out.
I have a main form (MainForm) that contains 2 subforms (subform1 & subform2).

MainForm contains a public sub called FilterSubForm2

The subform1 onCurrent event needs to call FilterSubForm2

I've tried

call me.form.parent.FilterSubForm2
call me.form.MainForm.FilterSubForm2

and various other derivations but keep getting the following error:

runtime error 2455
you entered an expression that has an invalid reference to the property Form/Report
End | Debug

If I hit the End button the code actually does what it's supposed to do!

Any ideas what's going wrong?

 

[wazz]

i don't think you need all the extra stuff. just type:
FilterSubForm2
hth

 

[boblarson]

Plus you don't need FORM when referring to the parent, but you do if you are referring to the subform within a subform container control.

call me.parent.FilterSubForm2

 

[MStef]

If the error still appear, try next,
before your code put;

On Error Resume Next

 

[mad-q]

Hello

I have been searching for ages for a solution to my problem, I am trying to call a public sub within a subform.

The main form is call Document Details
The subform is called DocumentDetailsSubform
and the sub is called GoToFirstRecord

I use
call me.form.DocumentDetailsSubform.GoToFirstRecord

and it returns the error
Run time error 438, Object doesn't support this property or method

Any help would be most appreciated.

Iain

 

[gemma-the-husky]

i struggle with anything where a subform is trying to manipulate its container.

it always strikes me as a design error.

what are you doing in the subform, that needs to invoke a function in its parent?

-----
Ok - having reread it, I can see why you might want to do this, so maybe the function in the parent is declared as private. it needs to be public, I think, and then you ought to able to just do something like this.

parent.mysub

 

[mad-q]

You are correct, it is a bit of a bodge. I have now changed the way I do it. (fix my code)

Thanks