Selecting from Data Sheet Style Subform

[woodm via AccessMonster.com]

Hi,

I am trying to create a Form with a datasheet type subForm from which I could
select a record and click a button on the Form that will use the selected
data from the subform to populate values in a MS Word Mail merge.
The Form is in data entry mode and has textboxes to enter new records into
the table that the subForm querys for records. This allows me to add new
records for selection in the subform. Basically I can't figure out how to
highlight or click on a record in the subForm and use that data in a macro,
preferably initiated by a button on the Form.

Any help on this would be much appreciated.

 

[Ken Snell [MVP]]

Assuming that the button is located on the main form, you reference the
value of a control in the subform's active record this way:

Me.SubformControlName!NameOfControlInSubform.Value

where SubformControlName is the name of the control that holds the subform
(which may or may not be the same name as the Source Object of that subform
control).