Skip to content

Finding the Correct Subform Reference Syntax

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.

 

A:  Yes, this works too.  But personally, what I really want is to return to the old (pre-Access 97) method of calling the Build dialog right from the module window – a very useful feature that was removed when VBA was made consistent across all Office applications.

About this author