Changing via a macro a text box property in a subform

[LesaM]

I need help in setting the text box property in an MS Access 2010 subform that had previously worked in the 2007 version. But, before I go any further let me say, I cannot use VBA in my development (a departmental restriction).
Originally the following macro setup generated a “control name ‘D1’ is misspelled or…” error:
If [Forms]![priAddS_Grid]![LvlGrpDesc]="Sup/Prem/Disc" then
SetProperty
Control Name: D1
Property: Visible
Value: 0


End If

(In the above, I’m using the primary form’s combo box value “Sup/Prem/Disc” to set the subform’s text box (D1) property)

I’m getting around the control name error by changing my macro to the following:
If [Forms]![priAddS_Grid]![LvlGrpDesc]="Sup/Prem/Disc" then
GoToControl
Control Name: frmS_GridIncCdLvlHiRate
GoToControl
Control Name: D1
SetProperty
Control Name:
Property: Visible
Value: 0
End If

But, the text box continues to be visible after the macro has run. The focus is in the D1 text box, but the property is unchanged.

Thank you in advance of any help that you can send my way.

Lesa

[June7]

What event runs this? Cannot set control that has focus to Not Visible or Not Enabled.

The issue that needs to be resolved is why the macro is not finding the named control.

Do you want to provide project for analysis?

[LesaM]

June7,
You may be right that the macro isn't finding the control to change the property. But the system isn't giving an error messge to confirm this problem.

Regarding you question on what event runs my macro.

The macro is triggered after an update of a combo box in the main form.

I'm new to this site and don't understand what you're asking here...Do you want to provide project for analysis?

Thanks again.

[June7]

You can attach the project (or other files) to post. Make copy, remove confidential data, run Compact & Repair, zip if large. The Attachment Manager is below the Advanced post editor.