Me!

Microsoft Access version 2.0 provides the reserved word "Me" as a shortcut to referencing the form object behind where the code resides. In other words, behind a form, any reference that you write as "Forms!<formname>" can now be made with the shorthand "Me." We take advantage of this shortcut in the Subform Wizard to get the selection the user has made in the list of subform fields. Below I have listed the code as it would look without the "Me" shortcut and how it looks with it.

Without Me!: sg_stReturnChild = Forms!zwfrmSubform!Sub
With Me!   : sg_stReturnChild = Me!Sub