Subform data

[krep]

Hello all,

This a quick repost/reiteration of something I posted yesterday.

i'm presenting the user with a subform populated by a multi-table view.
if i could have the
user freely update the view, i'd be set - but that's not possible. so,
i want the user to be able to click on a record within the subform to
make it active, or give it focus. ideally, the user would then click a
button which would update that record by sending the id of the focused
record to a stored procedure or subroutine. i know its gotta by
possible, but i'm not much of an msaccess-jockey... any ideas? again,
the problem is, how can the code grab the data from the focused subform
record?

Thanks!

 

[Jerry Porter]

<<how can the code grab the data from the focused subform record>>

If the subform object is named MySubform, and you wanted to get value
of a field MyField in the subform, use the following:

Me!MySubform.Form!MyField

This is assuming that the code is in the main form.

Jerry

 

[krep]

Doesn't seems to work. Error:
Microsoft Access can't find the field 'MySubform' referred to in your
expression. (Of course, I'm using my actual subform name in the actual
expression). Still searching for an answer.

 

[krep]

my apologies - it absolutely did work. thanks so much for your help.