Get data from Multiple Items Form Row on click

[takara]

I have a multiple Items Form that is filtered on load to show line items for an order. (user types in order #, multiple items form shows only the lines for that order)... this is working fine.



Once the form loads, it might show 4 lines.

How can I capture the data from that row when the user clicks the row (anywhere or any field in the row... it's ok if the user has to press a button on that row)

once I capture the data I can manipulate it fine, just can't figure out how to capture the data..

for now it'd be fine to show data in msgbox to see I can capture it.

e.g.
msgbox = me.form.detail.rowUserClicked.fieldname (I know thats not code)

If the user clicks row one, I want to capture the data from row 1 for example.

Thanks in Advance.

[CJ_London]

for

when the user clicks the row (anywhere or any field in the row... i

, use the form current event

Private Sub Form_Current
msgbox "A row has been clicked with this ID: " & ID
end sub

this assumes you have a control called ID - substitute ID with another control name if necessary

[June7]

I use the DblClick event of the form used as subform. Example:

Private Sub Form_DblClick(Cancel As Integer)
MsgBox Me!fieldname
End Sub

Otherwise, can use Click event of each control in the form or a button if in Single or Continuous view.

Current event would work but will also fire when navigating to record by navigation buttons or otherwise with code, not just when clicked on.

[takara]

wow, msgbox [line no_] works great thanks guys.. didn't think Access would automatically pass this so I didn't try. thanks again.