MS ACCESS/Macro/Subform's Control

Question

Greetings, 

I'm trying to reference a subform's control from main form. I'm using (trying) a command button with macro to hide "Qty" control on subform (via SetProperty). I have not been able to solve the correct syntax. I'm clear that the subform is considered as a control itself. As a result I'm using syntax as such

Forms![Main forms name]![subforms control name].Form![Qty] 

I've found several several answers (syntax) on the topic and tried numerous versions of all. Still no success. Just to simplify, (in macro) I only enter [subforms control name] . And subform becomes hidden (via ..Visibility , No). 

As soon as I try to get to the subforms control (any of them), macro error appears. Something to the affect "names not recognized". 

I've stried for success on different computers (w/ access 2013) and several different access files and forms. NO success. Any suggestions?

Answer 1

I would not use a macro for this myself, but I've experimented with one and get the same behaviour as you.  Are you obliged to use a macro, i.e. is this a 'web database'?  If not you should be able to do it with a single line of code in the command button's Click event procedure:

Me.[subform control name].Form.[Qty].Visible = False

Answer 2

Thanks Tom!!

Answer 3

Thanks so much Ken! Cheers!

Answer 4

To see if you have the right syntax, you could run the form, then hit Ctrl+G to go to the immediate window, where you can type a command such as:

Forms![Main forms name]![subforms control name].Form![Qty].Visible = False

and hit enter to see what happens.