field info from Subform

[RB]

Okay, I'm more than frustrated....

I've written some code on the Parent form and I'm trying
to look at a field on the subform

I tried Me!fldsubform.value - but it doesn't see the
subform. How can I access fields in my code that reside
on the subform.

Hope this makes sense......

 

[misha]

try

me.[subform]![control].property

where subform is the name of the subform control on the
parent form, control is the name of the contro you want to
reference on the subform, and property is the property
value you wish to retrieve.

 

[Graham Mandeno]

Hi RB

The syntax you need is:

Me.[subform control name].Form![subform field name]

Note that you must use the name of the *control* that contains the subform,
which is not necessarily the same as the name of the subform object in the
database window.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.