returning onFocus data from subform

[krep]

Is there a way to return to code any data form the subform record the
user clicks on? Since I can't udpate the data in the subform
(multi-table view) - i need to write an on-click function that updates
a table related to a record of the user's choice. so, instead of the
user being able to freely update that data, they'll simply click on a
button that will update whatever record current has focus. possible?

 

[krep]

this might actually be the most poorly worded subject heading and
posting of all time... please excuse - the brain just barely works this
late in the day...

 

[Pat Hartman\(MVP\)]

I've seen worse but I have to admit that I am not sure what you are trying
to do.

 

[krep]

i was afraid that might be a problem. ok... 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?

 

[Pat Hartman\(MVP\)]

I'm still having trouble with this. Was multi-table view a typo? Did you
really mean multi-row view? Why can't the user update the record? How will
you know how to update the record if you do it in a sub? Do you really want
to open a single view form that shows only the selected record?

I would chose one control on the form as the one to control the process and
add code to that control's DoubleClick event. So, when the user double
clicks in fldA, your event code will run. Does that help?

 

[krep]

Another poster hooked me up with:
Me!mySubForm.Form!thisField
worked like a charm.
thanks!