MS Access – Referring to a subform in a tab

Microsoft Access – referring to a subform contained within a tab on a main form from a popup form.

I’ve just had to remind myself how to refer to a subform contained within a tab on a main form.

I needed to get the value of a text field on the subform from within a popup form.

The format is as follows:

Forms![frmMain]![frmSubForm].Form![txtMyField]

Advertisements

1 Response to “MS Access – Referring to a subform in a tab”


  1. 1 Robert Lazo June 5, 2009 at 9:09 pm

    Thanks — syntax is specifically:

    Forms![frmMain]![frmSubForm].Form!txtMyField


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Blog Stats

  • 223,208 hits

Counter

ClustrMap


%d bloggers like this: