Error 2489 object isn't open.

[Leonel]

Thank you
I've been reading other threads and info on the web, but can't find a solution, so trying the gurus here.

I have a form with two sub-forms: FormA (subform control FormA_Subform) contains FormB and FormC (FormB_Subform FormC_Subform).

I want to display a specific record in FormC (DoCmd.SearchForRecord) when I click a record in Form B, but I keep on getting the error I mention in the title.

After some research, this is where I am:

I understand I need to place the focus on FormC, from FormB, before I can run DoCmd.SearchForRecord. Done using this code in FormB:



Me.Parent.SetFocus
Me.Parent!FormC_Subform.SetFocus

After this I've written:

DoCmd.SearchForRecord acDataForm, "FormC", acFirst, "[field]=condition".

But no luck. I've tried replacing FormC with FormC_Subform, Me.Parent!FormC, and Me.Parent!FormC_Subform, but it keeps on saying the object isn't open.



Thx for your help.
Leonel

[Minty]

See the attached page for how to reference forms and subforms from other forms
http://access.mvps.org/access/forms/frm0031.htm

Hopefully that will assist. It would probabaly help you enormously if you renamed the Sub Form Containers to something obviously different from the the sub form names. e.g. cntSubFormB etc.
You also seem to be referring to form A as if it is also a sub form? Correct or just me misunderstanding?

[Leonel]

Thank you Minty,

That page is one of my old favorites. You're correct on FormA as a subform. That's a mistake in the post. It's not named as a subform; it's FormA only.

lg

[John_G]

If you are in FormB, and you want to set the focus to a control in FormC, you will need something like this:

FormB.parent!FormC_container.form!FormC_Controlname.setfocus

You never need to refer to FormA explicitly - it is FormB's parent.

The important part is FormC_container - it is the name of the subform control (on FormA) that contains FormC.

Remember, too, that when referring to subforms, you rarely if ever have to use the actual form name - you use the name of the subform container the form is in.

[CJ_London]

You can do this without code

1. add a hidden textbox to formA and call it BLink. In the controlsource put

=[FormBSubformControlName].[Form].[Condition]

2. in the formC subform control on formA put field in the linkchild property and BLink in the linkmaster property

you description is not clear about field and control names so change names to suit