MS Access - refer to subform label

Question

4.33/5 (2 votes)

See more:

This is not your simple reference to a control on a subform. I need to set the caption for a label from an event in a subform. Here's the layout:

MainForm
- Subform1 (of MainForm)

- Subform2 (of MainForm)
- Label1 on Subform2

in the OnCurrent event of Subform1, I need to set the caption of Label1

I've tried everything I can think of.

Me.Parent!Subform2!Label1.Caption = "lorem ipsum"

Me!Forms!MainForm.Controls!Subform2!Label1.Caption = "lorem ipsum"

and others. Nothing works. Error is:

you entered an expression that has an invalid reference to the property form/report

TIA, AR.

Posted 16-Dec-13 10:20am

avianrand

Updated 16-Dec-13 10:23am

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-12-16T10:33:00

Solution 1

Try this:

VB

Dim lbl As Label
Set lbl = Me.Parent.Controls("SubForm2").Form.Controls("Label1")
lbl.Caption = "lorem ipsum"

Working with Controls on Forms and Reports[^]

Posted 16-Dec-13 10:33am

Maciej Los

Updated 16-Dec-13 10:37am

v2

MS Access - refer to subform label

1 solution

Solution 1

Add your solution here

Preview 0

MS Access - refer to subform label

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us