SubForm Control Names - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

SubForm Control Names

Joe Hood

5 years ago

Hello Richard,

I feel like I should know this by now, but my memory seems to be faltering at the moment. Can you tell me which class you covered specifying controls on a SubForm? Especially when using them in WHERE conditions.

Thanks Joe

	Alex Hedley @Reply 5 years ago
Value From a Form?

	Alex Hedley @Reply 5 years ago
Original Tip: Get a Value from an Open Form Field

	Richard Rost @Reply 5 years ago
Yeah these are tricky: `=Forms!ParentFormName!SubFormName.Form!ControlName` That what you're looking for? See Value From a Form

	Richard Rost @Reply 5 years ago
As always, Alex beat me to it. LOL

	Kevin Robertson @Reply 5 years ago
I have a Continuous Form within a Single Form within another Single Form. This has added yet another level of complexity.

	Alex Hedley @Reply 5 years ago
Form Inception :S

	Adam Schwanz @Reply 5 years ago
I was just typing that Alex ;D

	Joe Hood OP @Reply 5 years ago
Thanks Everyone for the Quick response. This is exactly what i was looking for. Have A Great Day! Joe

	Richard Rost @Reply 5 years ago
Bahahaha.... Let's get Leo on the phone. `Forms!FormName!SubForm1.Form!SubForm2.Form!SubForm3.Form!FieldName` Damn.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View