asked on 10/5/2011

Open form, sub form, control

Hi Experts.

I have a form with a subform and in the sub form there is a control, where i need to change the value.

The code is running from a Public Function in a Module.

Can some one help with this?

Microsoft Access

Last Comment

mbizup

10/5/2011

ASKER CERTIFIED SOLUTION

mbizup

10/5/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

DCRAPACCESS

10/5/2011

ASKER

I get a error when i try this:
MsgBox Forms!DCDK_ReportingInfo.Ekstra_reporting.Form.Controls(ctlname).Value

Also this give an error:
MsgBox Forms!DCDK_ReportingInfo.DCDK_ReportingInfo_ER.Form.Controls(ctlname).Value

"Ekstra_reporting" is the sub form name, the sub forms object name is "DCDK_ReportingInfo_ER".

The control name comes from a string ("ctlname").

mbizup

10/5/2011

What is the exact error?

DCRAPACCESS

10/5/2011

ASKER

It should be something like this, but can't get it to work:
Forms!Mainform!Subform1.Form!ControlName

peter57r

10/5/2011

You should not use the subform name anywhere in the command.(except by coincidence)

The subform reference needs to be the name of the subform container control on the main form.

Forms!mainformname!subformcontainercontrolname.Form!controlname

DCRAPACCESS

10/5/2011

ASKER

Sorry, my bad! I was referring to the wrong sub form name :-( Sorry for wasting every ones time mbizup wrote the right answer in the first response.

mbizup

10/5/2011

No trouble. The distinction Pete made is an important one, and I was lazy in my post. The name of the subform control is what is needed. That is the Name property of the 'frame' that houses the subform. It is frequently the same as the subform name, but not always.