A reader suggests an alternative method to referencing a subform control.
Q: Bob Massey writes to comment on my answer to Noni Nabong’s question in AW 9.03, where I gave the syntax for referencing a subform control. He suggests an alternate method, as follows:
I have mostly (99% of the time) resorted to MS Access’ own capability to locate a control in a drill-down reference. (Unfortunately) Open a query, new or old, on a field or criteria cell, right-click and choose “…Build..”. You then drill to the field of your choice. Once the fields has been clicked, the full reference is available in the builder’s build field.
I tend to double-check the reference by pasting it into the Immediate Window (Ctl+G) (placing a “?” at the beginning of the line), press enter and the “correct” answer should appear. The builder will return the full Forms!… reference, which I then modify to the “Me….” reference.